Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
INFO: Content Management Server Supports SQL Server Log Shipping for Failover
Article ID: 322742 - View products that this article applies to.
This article was previously published under Q322742
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: May 23, 2007 - Revision: 3.4