Post reply

Simulating Failure in AlwaysOn AG

  • July 5, 2016 at 5:12 am

    #311467

    I have implemented an AlwaysOn AG and configured it for synchronous replication and automatic failover but I find that when I stop the SQL Instance on the primary using SQL Server Configuration manager, the AG instance role does not automatically start on the secondary. What am I doing wrong?

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • July 5, 2016 at 8:14 am

    #1888461

    Br. Kenneth Igiri (7/5/2016)the AG instance role does not automatically start on the secondary.

    So you have two SQL instances with at least one Availability Group on there? Can you do a controlled failover successfully from SSMS?

    How many nodes are there in your failover cluster (i.e. do you have a fileshare witness or something like that to make a third node?).

  • July 5, 2016 at 3:05 pm

    #1888572

    Beatrix Kiddo (7/5/2016)

    Br. Kenneth Igiri (7/5/2016)the AG instance role does not automatically start on the secondary.

    So you have two SQL instances with at least one Availability Group on there? Can you do a controlled failover successfully from SSMS?

    How many nodes are there in your failover cluster (i.e. do you have a fileshare witness or something like that to make a third node?).

    There are two nodes in the cluster and one file share witness. And YES I can do a controlled failover successfuly. Works perfectly. But when I termintae SQL server service, the AG goes to failed mode on the cluster.

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • July 7, 2016 at 12:29 am

    #1888845

    Thanks all. I eventually solved this by setting the Maximum Failures in the specified period for the Cluster Role which has the same name as my Availability Group to a very high value. I want to believe this is the case simply because I was testing.

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

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

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