October 19, 2011 at 5:35 pm
Hi All,
Please help in solving the logshipping error. the database is being logshipped on the server. the Logship alert job is failing. the error message is
Msg 14421, Level 16, State 1, Procedure sp_check_log_shipping_monitor_alert, Line 61
The log shipping secondary database SQLD01.DBA has restore threshold of 45 minutes and is out of sync. No restore was performed for 1088308 minutes. Restored latency is 2 minutes. Check agent log and logshipping monitor information.
how to get rid of this error?
Thanking in Advance.
Regards
October 20, 2011 at 8:23 am
Disable the alert job and you wont get the message anymore
Easiest Way.
October 20, 2011 at 8:40 am
Are you sure that your log-shipping is actually working? The message implies that it has been a little over two years since the databases were last in sync.
There is an MSDN article on the checks to make for this message:
http://msdn.microsoft.com/en-us/library/aa337265(v=SQL.90).aspx
November 20, 2011 at 6:15 pm
I've seen this error a few times and usually the Log Shipping catches up. I've also seen some cases where it has stopped working all together and in that case I removed the log shipping and recreated it again using a full backup.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply