Monday, July 23, 2012

SQL Server 2012 Availability Group Replica Not Synchronizing

For some reason one of the databases in the availability group was stuck "Not Synchronizing" for a few days. A simple way to fix it was to simply pause & resume it using the SQL command found here: http://msdn.microsoft.com/en-us/library/ff877974.aspx

alter database <databasename> set hadr pause
alter database <databasename> set hadr resume

Synchronization immediately re-started and the database is now catching back up.  I'm not sure what happened, the event logs didn't show anything helpful but this did the trick.
:-\

4 comments:

  1. Uh oh. Didn't work for me. Back to Google...

    ReplyDelete
  2. Nailed it. A shortcut, for anyone wondering - if you right-click on the databases *in the Availability Group* you'll find the command to resume.

    ReplyDelete