FIX: "RESTORE DATABASE is terminating abnormally" error when you restore the secondary database in SQL Server 2012

Symptoms

Consider the following scenario:
  • You enable the AlwaysOn Availability Group feature in Microsoft SQL Server 2012.
  • You run an "ALTER DATABASE <DatabaseName> SET HADR OFF" statement to remove the secondary database from the availability group.
  • You try to restore the secondary database.
In this scenario, you receive the following error message:
Msg 4303, Level 16, State 1, Line 2
The roll forward start point is now at log sequence number
(LSN)#. Additional roll forward past LSN # is required to complete the restore sequence.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

Resolution

The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 6 for SQL Server 2012 SP1

About cumulative updates for SQL Server

Status

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

Article ID: 2884126 - Last Review: Oct 10, 2013 - Revision: 1

Microsoft SQL Server 2012 Service Pack 1, Microsoft SQL Server 2012 Developer, Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2012 Standard

Feedback