SQL 2005 Log Shipping - Was working, now isnt!
Posted
by Jim
on Server Fault
See other posts from Server Fault
or by Jim
Published on 2010-04-20T10:05:37Z
Indexed on
2010/04/20
10:13 UTC
Read the original article
Hit count: 345
Hello,
I had log shipping working between two SQL 2005 server fine.
I suspect that a job was added to the source server which backed up the transaction log to disk (nothing to do with the existing log shipping job).
As I understand it, if you do this then log shipping will fail to work.
Sure enough, it no longer works.
I've deleted the job which had just been created.
Log shipping still does not work.
I've rebooted both servers and, again, Log shipping does not work.
I'm at a loss now... all I get is the folloing error:
The log shipping secondary database XXXXXXXXXX has restore threshold of 45 minutes and is out of sync. No restore was performed for 5882 minutes. Restored latency is 15 minutes. Check agent log and logshipping monitor information.
Any help appreciated!
Thanks in advance.
© Server Fault or respective owner