Concept : Replication Vs Log Shipping Vs Mirroring - Mysqldog

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.

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 Concept : Replication Vs Log Shipping Vs Mirroring - Mysqldog Reviewed by admin on December 09, 2017 Rating: 5

No comments:

Powered by Blogger.