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.


6 comments:

Anonymous said...

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

Paul Sinnema said...

Thanks for sharing this. It threw me off as well

Alex F 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 LANDRY CIRHUZA said...

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

Post a Comment