Description of error message 14420 and error message 14421 that occur when you use log shipping in SQL Server (329133)
The information in this article applies to:
- Microsoft SQL Server 2000 Enterprise Edition
- Microsoft SQL Server 2000 Enterprise Evaluation Edition
- Microsoft SQL Server 2000 Developer Edition
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
- Microsoft SQL Server 2005 Workgroup
This article was previously published under Q329133 SUMMARYThis article discusses the reasons for "out of sync" error
messages when you have log shipping configured for SQL Server 2000.
One of the following error messages may be logged in the SQL Server
error log: Error message 14420Error: 14420, Severity: 16, State: 1 The
log shipping destination %s.%s is out of sync by %s
minutes. Error message 14421Error: 14421, Severity: 16,
State: 1 The log shipping destination %s.%s is out of sync by %s
minutes.If you are using SQL Server 2005, the description for these error messages are different: Error message 14420Error: 14420, Severity: 16, State: 1 The log shipping primary database %s.%s has backup threshold of %d minutes and has not performed a backup log operation for %d minutes. Check agent log and logshipping monitor information. Error message 14421Error: 14421, Severity: 16, State: 1 The log shipping secondary database %s.%s has restore threshold of %d minutes and is out of sync. No restore was performed for %d minutes. Restored latency is %d minutes. Check agent log and logshipping monitor information. REFERENCES
For additional information, click the following article number to view the
article in the Microsoft Knowledge Base: 314515
INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
321247 HOW TO: Configure Security for Log Shipping
Modification Type: | Major | Last Reviewed: | 12/10/2005 |
---|
Keywords: | kbhowto kberrmsg KB329133 kbAudDeveloper |
---|
|