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

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.

Recommendation: Install the latest cumulative update for SQL Server


About Service packs 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.

Thuộc tính

ID Bài viết: 3065060 - Xem lại Lần cuối: 16-11-2016 - Bản sửa đổi: 1

Phản hồi