Unable to create restore plan due to break in the LSN chain | SansSQL

Tuesday, August 27, 2013

Unable to create restore plan due to break in the LSN chain

Recently one of my colleague was working on restoring a database in SQL Server 2012 and the process had one Full database backup and one Differential Backup.
At first everything worked when they try to restore the full database backup with "No Recovery" and when they are trying to restore the differential backup, they were facing an issue which states "Unable to create restore plan due to break in the LSN chain."


Then we tried restoring the database using T-SQL scripts and it worked.
If you notice the screenshot, The information for "Restore to:" is empty which was supposed to show the timelines.
This seems to be a bug with SSMS and to work around this issue,
Right click on "Databases" folder and Choose "Restore Files and Filegroups..."


Now choose the differential backup file and this will restore the differential backup.


8 comments:

Anonymous said...

Thank you, i ran into this and it really threw me off. Your solution to Restore Files worked. Thanks again :D

Unknown said...

Thanks for sharing this. It threw me off as well

Unknown said...

Worked for me as well. Thanks!

Adnan said...

thank you so much.. nicely done

Unknown said...

Thank you! This saved me, because MS provided hotfix did not work

Koko Cirhuza said...

It doesnt work for my case! I have missing differential backups. Is there any way around this?

Unknown said...

Thank you very much for this helpful solution.
I just want to add one thing, while restoring the differential backup, go to options and select 'Override existing database', and since your full backup was restored with NO-RECOVERY, for this differential backup, choose to restore it with recovery if it was your latest diff backup file.

Charlotte W. said...

SQL Server is the base of all of our in-house servers. We use it to access all of our internal and external data that comes from Verint and other places. It solves our need to store the data that we have in one location and to create a data warehouse on top of it. Thank you~ Charlotte W. from web application security testing

Post a Comment

Ads