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.
:-\
Posted by Andrew Parisio at 8:58 AM

4 comments:

  1. GS2012April 2, 2013 at 8:32 PM

    Great job!!

    ReplyDelete
  2. muraliDecember 19, 2013 at 1:57 AM

    saved me

    ReplyDelete
  3. SDCJune 29, 2014 at 10:41 AM

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

    ReplyDelete
  4. UnknownOctober 31, 2014 at 10:28 PM

    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

Subscribe to: Post Comments (Atom)