Hi bill,
Please follow the following KB Article if u haven't gone thru
http://support.microsoft.com/kb/329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync" Errors
[quoted text, click to view] "bill" wrote:
> I have configured log shipping on SQL Server 2000, and all data is being
> restored correctly on destination servers within 30 minutes.
>
> The problem is the continuing failure of the Log Shipping Alert Job -
> Restore task.
>
> Every minute it records the error 14421 in the event log
>
> The log shipping destination ______ is out of sync by 12345 minutes.
>
> I have been told before that this error is not meaningful, and this appears
> to be true since the data is being restored correctly.
>
> However, some admin folks not knowledgeable about log shipping are troubled
> by the huge quantities of RED in the event log, and I don't blame them.
> They don't really accept a solution such as disabling the offending task,
> since this smacks of concealing a problem rather than resolving it.
>
> What can I do?
>
> -Bill
>
>