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:

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.


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

  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.