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


The information in this article 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.

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

Modification Type:MinorLast Reviewed:6/16/2006
Keywords:kbinfo kbwhitepaper KB323135
©2004 Microsoft Corporation. All rights reserved.