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

Applies to: SQL Server 2012 DeveloperSQL Server 2012 EnterpriseSQL Server 2012 Standard More

Symptoms


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.

Resolution


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




Workaround


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

Status


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