Microsoft KB Archive/323135

= Microsoft SQL Server 2000 - How to set up log shipping (White paper) =

Article ID: 323135

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Enterprise Edition

-



This article was previously published under Q323135



SUMMARY
The Log Shipping feature in Microsoft SQL Server 2000 Enterprise Edition is an automated process that sends transaction logs from one server to another. You can use Log Shipping to create a warm standby server for your production server.

A white paper for Database Administrators who have never used Log Shipping before and are interested in exploring Log Shipping as a strategy for disaster recovery is available; to access this white paper, please visit the following Microsoft Web site:

http://download.microsoft.com/download/SQLSVR2000/Utility/2.0/WIN98/EN-US/log_shipping.exe

Included in this document:


 * The steps to configure Log Shipping between two or more servers that are running SQL Server 2000 Enterprise Edition.
 * The steps to configure Log Shipping between Microsoft SQL Server 7.0 Service Pack 2 (SP2), or later, and Microsoft SQL Server 2000 Enterprise Edition.
 * A brief comparison between Log Shipping and the other high availability-solutions that SQL Server provides.

