November 29, 2011 at 8:40 am
Hi,
I just notice logshipping restore job is failling on Secondary server not sure how long but copy job is running successfully.
I tried to execute restore job and got below error.
*** Error: The log in this backup set begins at LSN 7291000009045100001, which is too recent to apply to the database. An earlier log backup that includes LSN 7291000006306300001 can be restored.
Can you please help me to resolve this issue.
November 29, 2011 at 8:51 am
You missed some of the logs in chain... a Broken Log Chain.
November 29, 2011 at 8:52 am
Restore the last FULL Backup, then Differential backup (if any) & finally all log backups in proper sequence.
November 29, 2011 at 9:00 am
You can review the restore history in msdb to determine the last successfull restore. If you still have access to the log files, you can just pick up from that point forward until current. The automated process will continue on from there once it's at the correct point.
November 29, 2011 at 9:40 am
I try to look for log files but not able to find. so i am thiking to remove the Logshipping and set-up again or is there any other way to perform this task??
November 30, 2011 at 6:47 am
Jinu43 (11/29/2011)
I try to look for log files but not able to find. so i am thiking to remove the Logshipping and set-up again or is there any other way to perform this task??
You dont have to remove log shipping, just restore a full backup and all subsequent logs, leave the DB in standby so that more logs can be applied.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply