September 20, 2011 at 7:54 am
Hi All,
Need help fast
I have setup log shipping 3 days. Below is the configuration.
SQL Server 2008 R2
Primary->Secondary Standby readonly with monitor setup on primary
Everything was working fine until today in the morning at 8:30 am I started getting alerts to my email. When I checked the log shipping status report on both the primary and secondary servers I found the copy and restore jobs stopped working absolutely.
The last copy and restores were done at 8:15 am and thats it no more are happening.
While I am typing this, one by one the other databases that are setup for log shipping are also failing due to the same issues.
Error message in Alert job:
Date9/20/2011 8:30:00 AM
LogJob History (LSAlert_RDU30D-FHZZSH1\VAMSIDEV08)
Step ID1
ServerServer1
Job NameLSAlert_Server1
Step NameLog shipping alert job step.
Duration00:00:00
Sql Severity16
Sql Message ID14420
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
Executed as user: testuser. The log shipping primary database Server2.TestDB6_RPT has backup threshold of 45 minutes and has not performed a backup log operation for -246285 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14420). The step failed.
Error message in application log of event viewer:
The log shipping primary database Server2.TestDB6_RPT has backup threshold of 45 minutes and has not performed a backup log operation for -246285 minutes. Check agent log and logshipping monitor information.
Attached the snapshot of the jobs status in log shipping report too!
Thanks in advance!
September 20, 2011 at 9:51 am
Figured it out. One of developers changed the time on the server to 2012 which caused the issue! These developers! :w00t:
September 20, 2011 at 10:59 am
Those darn clock skew errors :-D!
September 21, 2011 at 3:56 am
Never give admin rights to DEV team.
"More Green More Oxygen !! Plant a tree today"
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply