Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kkk514
Starting Member
8 Posts |
 Posted - 2010-07-19 : 13:14:11
|
| Hi All,I have some databases in log shipping and I find that the backup, copy and resotre jobs are working fine for all databses.However, the alert job is failing with following error for one databse when I execute:exec sys.sp_check_log_shipping_monitor_alert Msg 14421, Level 16, State 1, Procedure sp_check_log_shipping_monitor_alert, Line 61The log shipping secondary database ABC(Secondaydb) has restore threshold of 45 minutes and is out of sync. No restore was performed for 1414897 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information.Any help is appreciated.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kkk514
Starting Member
8 Posts |
Posted - 2010-07-19 : 14:12:31
|
| Thank you Tara for your reply.I have verfied the files at Primary (with date-time and file size), they are being copied and restored at the secondary successfully. FYI.. We are seeing this issues since yesterday, as we had a failover from one node to other.Please let me know, if I need to check anything else.Thanks |
 |
|
|
|
|
|
Log shipping out of sync