SQL Server 2008 Logshipping not Restoring

Posted by Nai on Server Fault See other posts from Server Fault or by Nai
Published on 2010-04-01T09:26:59Z Indexed on 2010/04/01 9:33 UTC
Read the original article Hit count: 634

Filed under:
|

I am getting the following errors during the restore part of the Logshipping process on my secondary server:

2010-04-01 10:00:01.85 Error: The file 'F:\UK_20100327090001.trn' is too recent to apply to the secondary database 'UK_Backup'.(Microsoft.SqlServer.Management.LogShipping)

2010-04-01 10:00:01.85 Error: The log in this backup set begins at LSN 55408000007387500001, which is too recent to apply to the database. An earlier log backup that includes LSN 55147000001788900001 can be restored. RESTORE LOG is terminating abnormally.(.Net SqlClient Data Provider)

2010-04-01 10:00:01.87 Searching for an older log backup file. Secondary Database: 'UK_Backup'

2010-04-01 10:00:01.90 Skipped log backup file. Secondary DB: 'UK_Backup', File: 'F:\UK_20100324090000.trn'

2010-04-01 10:00:01.93 Error: Could not find a log backup file that could be applied to secondary database 'UK_Backup'.(Microsoft.SqlServer.Management.LogShipping)

2010-04-01 10:00:01.93 Deleting old log backup files. Primary Database: 'UK'

2010-04-01 10:00:01.96 The restore operation completed with errors. Secondary ID: 'c066bb63-930c-4b73-861c-f59f0a38c12c'

It was happily humming along until I checked it this morning.

Some additional details. In the Logshipping folder, there is one file UK_20100324090001.trn dated on the 2009-3-24. The next most recent .trn file is the UK_20100374090001.trn which is the file that was applied during the restore.

  1. Why is there an older trn file seemingly on it's own?
  2. How can I fix this problem? It'll be a real pain to restart the entire logshipping process. x_x

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about backup