Restore Logs error
dwjongbloed
Posts: 30
I have a job that restores a Full backup at 2:30 am. The Full backup is taken at 12:30 am. The restore leaves the database to where I can restore the logs if needed. However when I try to go and restore the logs I get SQL Error 4305: The log in this backup set begings at LSN XXXX, whi is too recent to apply to the database. An earlier log backup that includes LSN XXXX can be restored.
I was trying to restore the log backup from 1 am.
Can anyone help me out on this? What is going on?
I was trying to restore the log backup from 1 am.
Can anyone help me out on this? What is going on?
Comments
Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8