AG in Resolving state

  • I have a 2 node cluster on server 2012r2/sql2014. Recent patching (thanks MS) took down one of the nodes hard. The second one won't come out of the Resolving state. Any ideas?

    There is an exception to every rule, except this one...

  • We have lots tickets with MS re AlwaysOn

    even you leave the current status for them remote in to investigate, they will say not enough information.

    Here are my summary to fix Alwayson.

    1. ALTER DATABASE [DatabaseName] SET HADR RESUME;

    If it doesn't work see below.

    2. Change sync mode

    USE [master]

    GO

    ALTER AVAILABILITY GROUP [AG]

    MODIFY REPLICA ON N'SQLServer\INSTANCE3' WITH (AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT)

    GO

    USE [master]

    GO

    ALTER AVAILABILITY GROUP [AG]

    MODIFY REPLICA ON N'SQLServer\INSTANCE3' WITH (AVAILABILITY_MODE = SYNCHRONOUS_COMMIT)

    GO

    If still not working, try 3:

    3. remove db from AG, then add it back.

    ALTER DATABASE [DatabaseName] SET HADR OFF;

    GO

    alter database [DatabaseName] set HADR AVAILABILITY GROUP = [AG]

    go

    If 3 still not work, rebuild the AG, 4:

    4. Drop database and restore from scratch.

    ALTER DATABASE [DatabaseName] SET HADR OFF;

    GO

    drop database [OdysseyXXXYYY]

    restore database DatabaseName from disk = '\Restored\DatabaseName' with norecovery

    restore log DatabaseName from disk = 'Restored\DatabaseName_latest.trn' with norecovery

    join the database to AG now.

  • SQLHeap (7/30/2015)


    I have a 2 node cluster on server 2012r2/sql2014. Recent patching (thanks MS) took down one of the nodes hard. The second one won't come out of the Resolving state. Any ideas?

    I believe this is related to a particular patch being installed, cant remember which one now, if I find it i'll post the link

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Update: we had to drop the AG alltogether and restart the server.:angry:

    There is an exception to every rule, except this one...

  • Oh ya, and I do appreciate the responses!

    There is an exception to every rule, except this one...

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply