Primary server stay on resolving state- Always ON

  • WhiteLotus

    SSChampion

    Points: 11878

    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

    SSC-Dedicated

    Points: 32376

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

  • WhiteLotus

    SSChampion

    Points: 11878

    HI

    Thanks for the response

    How do i check if we have witness or not?

    Cheers,

    Murni

     

  • as1981

    SSCrazy

    Points: 2380

    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