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:
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.
REFERENCES
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
917544 BUG: You receive an error message when you run the "Log Shipping Alert Job - Restore" job in SQL Server 2000
Keywords: kbinfo kbwhitepaper KB323135
