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 either of the following options:
Mirroring, to establish a single standby that will come online if the principal 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 ...
Get Microsoft® SQL Server® 2008 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.
