Hi
So we built our first SQL 2017 Always On availability group but occasionally it is automatically failing over without taking the windows cluster with it so the alias points to the secondary instance which takes the system down :(.
Is there something obvious we have done wrong?
Technically I don't need automatic failover (althoughI would prefer it) but when I switched it off Windows failed over but sql did not.
Thanks in advance
Phil