19.9. Integrating Log Shipping with Other High-Availability Solutions

Log shipping can be deployed along with other Microsoft high-availability solutions (e.g., in a Windows failover cluster, where it maintains a remote disaster recovery site if the local Windows failover cluster becomes unavailable). Moreover, it can be deployed with data mirroring to maintain a remote site if the data-mirroring pair becomes unavailable. Log shipping can also be deployed with replication to maintain a highly available replication publisher.

19.9.1. SQL Server 2008 Data Mirroring

Log shipping can be integrated with a SQL Server 2008 data mirroring solution. For example, an organization may deploy local data mirroring and log shipping from the principal server to a remote location. This would be applicable because data mirroring cannot have more than two partners; therefore, if an organization wants to protect its data investment by using local data mirroring for high availability but requires a business continuity plan for disaster recovery, it can deploy log shipping from the primary server to a remote secondary server. However, during a data-mirroring role switch, log shipping will not automatically switch roles, and manual steps must be taken to enable the former mirror, which is now the principal, to start to log ship its transaction log to the secondary server by deploying log shipping from the new principal server.

19.9.2. Windows Failover Clustering

Log shipping can be deployed to ship ...

Get Professional Microsoft® SQL Server® 2008 Administration 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.