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.