- 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.
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.
Article ID: 2884126 - Last Review: Oct 10, 2013 - Revision: 1