Tuesday, March 27, 2012

database mirroring vs log shipping

what could be the difference database mirroring vs log shipping in terms of
redundancy and performance.
thanks.
Hi Chris
"chris" wrote:

> what could be the difference database mirroring vs log shipping in terms of
> redundancy and performance.
> thanks.
I believe the difference is mainly in the latency, with database mirroring
providing a warmer standby than log shipping! Mirroring provides a method of
automatic failover to a single mirrored database, log shipping can service
multiple standby databases and requires manual intervention to make it live,
see
http://msdn2.microsoft.com/en-us/library/ms190202.aspx and
http://msdn2.microsoft.com/en-us/library/ms187016.aspx
John
sql

No comments:

Post a Comment