AlwaysON Bug with Failure to Restore the Backup Performed on Secondary Server
AlwaysON Availability Groups are one of the most popular feature introduced with SQL Server 2012 with SP2. With introduction of every new release, comes lot of new features and functionality, but at the same time also comes lot of bugs or problems. Some of the issues found or raised or faced will be very basic, yet creates lot of issues. One of such issue with SQL Server 2012 AlwaysON is “Error 4360 when you restore the backup of secondary replica to another server in AlwaysOn Availability Groups“. AlwaysON Availability Groups setup in SQL Server 2012 and when you perform log back up of a database from the secondary replica, and then try to restore the log backup file to another server after a restore of full/diff backup and in this situation, you may receive the below error message
Msg 4360, Level 16, State 1, Line 1
RESTORE LOG WITH CONTINUE_AFTER_ERROR was unsuccessful. Execution of the RESTORE command was aborted.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
This issue has been notified to Microsoft by various customers and raised as a bug. This issue has been addressed by Microsoft SQL Server Product team and a fix has been released for the same which is available with Cumulative Update 5 for SQL Server 2012 SP2. Once you apply this fix, you should be able to restore the log backups performed on AlwaysON Availability Group database on secondary server to some other server.
Although the issue can be fixed by applying CU5 for SQL Server 2012 SP2, it is advisable to apply latest available CU for SQL Server 2012 SP2, to avoid any other known issues or failures too. Each new cumulative update released for SQL Server will contain all the hotfixes and all the security fixes that were included with the previous cumulative update. We recommend that you download and install the latest cumulative updates for SQL Server:
Hope this was helpful.
This is applicable for below versions of SQL Server
SQL Server 2012 SP2
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, Frequently asked questions, SQL Server Trainings