| Log Shipping |
Mirroring |
| It is manual fail over process. |
It is automatic fail over process. |
| Here we can add n no. of secondaries to single primary server. |
There is no possibility to add multiple mirror servers to a principal serve.r |
| Data updations runs through jobs. |
Data updations are happening through end points. |
| In log shipping we are configuring secondary server with standby mode so that reporting purpose is used. |
In mirroring we will always configure mirror server in no-recover mode reporting is not possible. |
| Data loss may be occur due to damage of data or log file. |
Here zero data loss. |
| Here we will have monitor server to monitor the log shipping databases. |
Here we will have witness server to monitor the mirroring databases. |
No comments:
Post a Comment