Using Mirroring and Log Shipping
Mirroring and log shipping are two different options that you can use to improve availability. The principal database used in database mirroring can act as the primary database in log shipping as well. You might want to do this is in a situation in which you have a critical database and you want to have multiple standby servers available. For example, you might use:
Mirroring to establish a single standby that will come online if the primary fails. With a fully synchronous mirroring configuration, automatic failover occurs if the principal database is lost, as long as the mirror server and witness can communicate with each other. Automatic failover causes the mirror server to assume the principal role and bring ...
Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
