Availability Group Failover

  • garryha

    SSC-Addicted

    Points: 407

    Hi

    We have a Avaliabilty group setup with a 4 node (plus cloud witness) setup.  Two of each nodes are in seperate dataceneters and HA partners.

    It hasn't been an issue until now but in the last 5 crazy days one node, has a couple of times, failed over to the other HA node.  It has just been this one and none of the other AGs on the cluster.

    Where would you start to look to find out why it has failed over?

  • as1981

    SSCrazy

    Points: 2681

    If I understand your setup correctly then there should be something in the following locations:

    Windows Cluster event logs

    SQL Server logs

Viewing 2 posts - 1 through 2 (of 2 total)

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