Mirroring Vs Log Shipping Vs Replication

Mirroring:
The database mirroring is a software solution mainly to develop the availability of the database.
Maintains two copies of a single database that must reside on different instances of SQL Server database engine server.
Maintains two copies of a single database that must reside on different instances of SQL Server database engine server.
Log Shipping:
Sends transaction log backups from one database to a database on another server automatically. A third optional server, known as the monitor server, records the history and status of backup and restore operations.
The monitoring server can alert if these operations do not occur as scheduled.
Replication:
It is a set of technologies to copy and sharing data objects and databases from one database to another database and then synchronize between databases to occur consistency.
Through process of replication, you can share data to multiple locations and to remote or mobile clients across local area and wide area networks, dial-up, wireless, and the Internet connections.
Concept : Replication Vs Log Shipping Vs Mirroring - Mysqldog
Reviewed by admin
on
December 09, 2017
Rating:
Reviewed by admin
on
December 09, 2017
Rating:
No comments: