SQL Server Performance Forum – Threads Archive

manual copy transaction log

If for certain reason, one transaction log backup is corrupted after copying from primary server to secondary server. the error "The log in this backup set begins at LSN 33000000022600001, which is too late to apply to the database. An earlier log backup that includes LSN 33000000011800001 can be restored." is prompted. Is it possible to manually copy the lost transaction log backup to secondary server to let the restore job proceeds? Thx [<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ />]

This should not be a corrupted tran log backup, rather the restore has come to an out of sync state. I guess you might need to restore the FULL backup and then start the tran log process again.

True and in order to restart the log shipping process you must restore the full backup from primary server to secondary server. Check whether any network issues persisting while copying the file and also check the log shipping restore interval. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>