Article ID: 322742 - View products that this article applies to.
This article was previously published under Q322742
This article has been archived. It is offered "as is" and will no longer be updated.
Log shipping as a form of failover for Content Management Server (CMS) computers has been tested and is supported.
SQL Server log shipping is designed to provide a means of backup and to ensure failover protection if a system failure occurs. Log shipping works by continually backing up and restoring database logs to either a single computer that is running SQL Server or multiple standby computers that are running SQL Server.
The idea behind this is that in a failure, a database administrator can make one of the backup servers available to a CMS server. By re-running the Database Configuration Application (DCA) and pointing to the new server, the down time can be reduced to a minimum.
There are several things to consider, from a CMS standpoint, when a SQL Server failure occurs:
For more information about log shipping and typical models for its deployment, visit the following Microsoft Developer Network (MSDN) Web site:
Log ShippingFor additional information, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/314515/EN-US/ )INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
Article ID: 322742 - Last Review: February 27, 2014 - Revision: 3.4