SQL 2005 Log Shipping - Was working, now isnt!
- by Jim
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.