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: 315

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

Related posts about sql-server-2005

Related posts about sql-server