Primary server stay on resolving state- Always ON

  • WhiteLotus


    Points: 11932

    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


  • Beatrix Kiddo


    Points: 32407

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

  • WhiteLotus


    Points: 11932


    Thanks for the response

    How do i check if we have witness or not?




  • as1981


    Points: 2734

    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 4 (of 4 total)

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