backup begins at LSN which is too recent to apply

Question

backup begins at LSN which is too recent to apply

sqlwars

SSC-Addicted

Points: 416
More actions
May 4, 2010 at 12:57 am

#232247

My restore failed with the error: backup begins at LSN which is too recent to apply.
On checking backup history: i have the following backups taken:
Missing LSN backup 2:30 AM - Tlog
backup2 10:30 PM - Tlog
FUll backup 10:45 PM - Full
Backup 4 11:00 PM - Tlog
backup 5 11:30 PM - Tlog - MOST current backup
Since there is a full backup in between the missing lsn and current backup, i feel taking a full backup and restoring is the best possible way.
Please let me know if I am correct?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

sqlwars (5/4/2010)
My restore failed with the error: backup begins at LSN which is too recent to apply.
On checking backup history: i have the following backups taken:
Missing LSN backup 2:30 AM - Tlog
backup2 10:30 PM - Tlog
FUll backup 10:45 PM - Full
Backup 4 11:00 PM - Tlog
backup 5 11:30 PM - Tlog - MOST current backup
Since there is a full backup in between the missing lsn and current backup, i feel taking a full backup and restoring is the best possible way.
Please let me know if I am correct?

restoration needs some sequence. refer this link

http://www.databasejournal.com/features/mssql/article.php/3591131/COPYONLY-Backups-in-SQL-Server-2005.htm it might help you.

Additionally what you are getting with

select message_id, severity, [text] from sys.messages where language_id = 1033 and severity <> 10 and [text] like ‘%backup%’

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

With the backups that you list, you can restore using the full backup and the last 2 transaction log backups. What happened to the file from the log backup at 2:30?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

sqlwars SSC-Addicted Points: 416 More actions · Answer 3

http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(2030)-restarting-a-log-backup-chain-requires-a-full-backup.aspx

gave teh detailed explanation and cleared few myths too!