Article ID: 323135 - Last Review: February 22, 2007 - Revision: 5.4

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

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q323135
Expand all | Collapse all

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 (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.

REFERENCES

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
917544  (http://support.microsoft.com/kb/917544/ ) BUG: You receive an error message when you run the "Log Shipping Alert Job - Restore" job in SQL Server 2000
APPLIES TO
  • Microsoft SQL Server 2000 Enterprise Edition
Back to the top
Keywords: 
kbinfo kbwhitepaper KB323135