Log Shipping

Log shipping in SQL Server 2000 provides a means of establishing a warm back up solution by using the SQL Server Maintenance Plan Wizard. Transaction log backups from a database can be automatically shipped to a different server and applied to a standby database. You can use the standby database to perform read-only operations (depending on the load state).

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:   https://download.microsoft.com/download/SQLSVR2000/Utility/2.0/WIN98/EN-US/log_shipping.exe

 

Frequently asked questions - SQL Server 2000 - Log shipping https://support.microsoft.com/default.aspx?scid=kb;EN-US;314515

 

How to configure security for SQL Server log shipping https://support.microsoft.com/default.aspx?scid=kb;EN-US;321247

 

For more information about log shipping and typical models for its deployment, visit the following Microsoft Developer Network (MSDN) Web site:
Log Shipping https://msdn2.microsoft.com/en-us/library/aa213785(SQL.80).aspx

 

Backup, copy, and load job information is not updated on the log shipping monitor https://support.microsoft.com/default.aspx?scid=kb;EN-US;292586

 

Description of error message 14420 and error message 14421 that occur when you use log shipping in SQL Server https://support.microsoft.com/default.aspx?scid=kb;EN-US;329133

 

Log Shipping Monitor out-of-synchronization messages are incorrectly raised in an outage period in Microsoft SQL Server 2000 Enterprise Edition
https://support.microsoft.com/default.aspx?scid=kb;EN-US;311177

 

Support WebCast: Microsoft SQL Server 2000 Log Shipping https://support.microsoft.com/default.aspx?scid=kb;EN-US;325220

 

Support WebCast: Microsoft SQL Server 2000: Using Log Shipping https://support.microsoft.com/default.aspx?scid=kb;EN-US;821786