Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Microsoft SQL Server 2000 - How to set up log shipping (White paper)

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

View products that this article applies to.

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.

↑ Back to the top

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

↑ Back to the top

Keywords: kbinfo, kbwhitepaper, KB323135

↑ Back to the top

Article Info
Article ID : 323135
Revision : 9
Created on : 2/22/2007
Published on : 2/22/2007
Exists online : False
Views : 339