Advantages & Disadvantages of Database Mirroring

Advantages Database Mirroring:

  • Database Mirroring architecture is more robust and efficient than Database Log Shipping. It can be configured to replicate the changes synchronously to minimized data loss.
  • It has automatic server failover and client failover mechanism.
  • Configuration is simpler than log shipping and replication, and has built-in network encryption support (AES algorithm).
  • Because propagation can be done asynchronously, it requires less bandwidth than synchronous method (e.g. host-based replication, clustering) and is not limited by geographical distance with current technology.
  • Database mirroring supports full-text catalogs.
  • Does not require special hardware (such as shared storage, heart-beat connection) and clusterware, thus potentially has lower infrastructure cost

Disadvantages of Log Shipping:

  • Potential data lost is possible in asynchronous operation mode. RTO will vary and depend on several factors, such as propagation interval time and bandwidth speed.
  • Mirror server/database is not available for user operation.
  • It only works at database level and not at server level. It only propagates changes at database level, no server level objects, such as logins and fixed server role membership, can be propagated.
  • Automatic server failover may not be suitable for application using multiple databases.

Leave a Reply

Join the Conversation


Leave a comment

Your email address will not be published. Required fields are marked *



Related Posts

How to Move mirrored database files
The following article describes how to move the database files of a mirrored database to a new location without any downtime. Basically I have th...
How to configure Database Mirroring
I have configured database mirroring with database sansu as the principal and with following 3 instances namely, Deepak ---> Principal D...
Comparison between Mirroring VS Log shipping and Mirroring VS Clustering
Database Mirroring Vs Clustering Clustering Database Mirroring Clustering failover using SQL Virtual Server provides the hi...
powered by RelatedPosts