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.
Best Answer
as you have added the tlog bkp in between your sequence of tlog on log shipping got disturb.
The quickest workaround is start your full backup and restore that full backup (Jobs) and then tlog will take from there.
*Hope you have removed an extra tlog backup.