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
I forgot to mention, I'm using SP3, which was supposed to correct this
problem.
I haven't had a chance to install SP4 on the primary yet.
One of the destination servers has SP4 - would that cause the error?
Thanks
Bill
|||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
"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
>
>
Wednesday, March 21, 2012
Error 14421
Labels:
beingrestored,
configured,
correctly,
database,
destination,
error,
log,
microsoft,
mysql,
oracle,
server,
servers,
shipping,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment