Restore Logs error

Forum for users of Red Gate SQL Backup tool

Moderator: Chris Auckland

Restore Logs error

Postby dwjongbloed » Thu Aug 26, 2010 1:14 pm

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?
dwjongbloed
 
Posts: 15
Joined: Mon Nov 26, 2007 10:10 pm
Location: Willmar, MN

Postby petey » Mon Aug 30, 2010 8:02 am

It looks like there was another transaction log backup taken before 1 am. Try looking in the msdb..backupset table and check if there were any log backups taken before 1 am.

Thanks.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests