Post reply

Primary server stay on resolving state- Always ON

  • September 16, 2019 at 5:43 am

    #3680190

    Hi All ,

    In my case we’re Looking the cause why in our Always On SQL when we lost communication on the secondary replica the primary goes down (stay on the Resolving state)

    Any thoughts please

    Thank you

     

  • September 16, 2019 at 12:07 pm

    #3680274

    What is your cluster quorum mode? Do you have a fileshare witness or disk witness, or anything?

  • September 17, 2019 at 12:06 am

    #3680517

    HI

    Thanks for the response

    How do i check if we have witness or not?

    Cheers,

    Murni

     

  • September 17, 2019 at 2:44 pm

    #3680729

    You need to have a look at the Windows Cluster manager for the Windows servers that SQL is running on. As you may know 'Always On' relies on a cluster created using Windows Failover Clustering.

    You should be able to find information online about how to access that on the version of Windows you are using. If you can't find the information then post the information and someone should be able to advise.

    It should show you the state of the cluster, the items included in it (File Share Witness e.t.c. as the previous reply mentioned) and any errors as well. If you can let us know what's there we can try and advise.

     

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

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