Sometimes when you restore your database backup you can get “Unable to Create Restore Plan Due to Break in the LSN Chain” error. Let’s see how to deal with it.
Let’s assume that you have to administer a database with the help of Microsoft SQL Server Management Studio (SSMS). All backups are made as scheduled and everything works just fine, and then, all of a sudden, a failure occurs and now you need to restore your database. You have all backups that you need to restore your database, so you start the restoration process from the last full backup with NORECOVERY option. After a successful operation you restore last differential backup file with the RECOVERY option but suddenly something goes wrong and you get the following error message:
Unable to create restore plan due to break in the LSN chain.
This error occurs due to a problem with Microsoft products, and can occur in SQL Server Management Objects and only when you use Microsoft SQL Server Management Studio for database recovery.
To solve this issue you need to restore the database manually using the following T-SQL commands to perform full and differential backups:
RESTORE DATABASE your_database FROM DISK = 'full.bak' WITH NORECOVERY, REPLACE RESTORE DATABASE your_database FROM DISK = 'diff.bak' WITH RECOVERY
If you prefer to continue working with Microsoft SQL Server Management Studio you have to restore backups not one by one but all at once.
Also, Microsoft recommends installing the latest cumulative update for SQL Server to avoid getting “unable to create restore plan due to break in the lsn chain” error message in future.