Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Log shipping help

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2010-07-28 : 16:13:27
Hi All,
in log shipping environment, at the secondary, agent got sptopped, and just now i checked and started again. mirroring is fine in the server, but logshipping, the restore job is failing with the below error. the full backup is only 3Gb, to reconfigure again, i need to copy that between datacenters, it takes around 2 hours for me. so, restoring a full backup, no chance. how can i make it sync?

error

Error: Could not find a log backup file that could be applied to secondary database 'mydb'.
(Microsoft.SqlServer.Management.LogShipping)

More Info:
Error:
Error: The file 'j:\sql_backup\Logshipping\mydb_20100725163004.trn' is too recent to apply to the secondary database 'mydb'.(Microsoft.SqlServer.Management.LogShipping) ***
Arnav
Even you learn 1%, Learn it with 100% confidence.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-28 : 17:08:38
You need to apply whatever transaction log backup that is earlier that hasn't yet been applied to the secondary server. You can do it manually to get it back in sync, provided that you have all of the tlog backups from the primary that haven't been applied to the secondary.

Use RESTORE LOG WITH NORECOVERY or RESTORE LOG WITH STANDBY.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -