FIX: "Unable to create restore plan due to break in the LSN chain" error when you restore differential backup in SSMS


Assume that you create a full backup file and a differential backup file in Microsoft SQL Server Management Studio (SSMS). When you restore the full backup file by using the NORECOVERY option, and then you restore the differential backup file by using the RECOVERY option in SSMS, the operation fails, and you receive the following error message:
Unable to create restore plan due to break in the LSN chain. (Microsoft.SqlServer.SmoExtended)

Note This problem occurs in SSMS and SQL Server Management Objects (SMO), but not in SQL Server engine.


The issue was first fixed in the following Service Packs and cumulative update for SQL Server.

Recommendation: Install the latest cumulative update for SQL Server

About Service packs for SQL Server


To work around this issue, use the TSQL command and the same backup file to restore the database.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


ID do Artigo: 3065060 - Última Revisão: 16/11/2016 - Revisão: 1