Labels

Sunday, 27 December 2015

SQL Server - Difference between Mirroring and Log Shipping

The below are the differences between Mirroring and Log Shipping.

1.To implement Mirroring database recovery model should be FULL and SQL Server 2005 SP1 or higher with Enterprise or Developer Edition required. where as to implement Log Shipping database recovery model can be either Full or Bulk-Logged and SQL Server 2000 and even standard edition for 2005 can works.

2. In Mirroring both Principal and Mirror Server should have same edition where as in Log Shipping
Primary and secondary server should be compatible for restore.

3. Mirroring is automatic / manual failover where as Log Shipping is only Manual failover.

4. In Mirroring secondary database should be restored in with no-recovery mode where as in Log Shipping secondary database can be use restoring with no-recovery / stand-by mode.

5. In Mirroring 2 or 3 seconds only required to failover mirror database where as in Log Shipping
around 30 minutes required to failover secondary database.

6. In mirroring only committed transactions are transferred where as in Log Shipping all committed
and un-committed transactions are transferred .

7. In Mirroring we can maintain only one mirror database where as in Log Shipping we can maintain 1 / more secondary databases.

8. In Mirroring PAGE repair is possible if principal database page gets corrupt where as in Log Shipping PAGE repair is not possible.

No comments:

Post a Comment