We have had a RAID card on one of our switches die, and the replacement had issues which caused my availability groups to failover multiple times between my 2 nodes like a game of tennis and left a few databases in an unhealthy state.
Obviously, the card needs to still be replaced again and I want to be able to set a maintenance setting to not have the databases failover repeatedly for what will be a brief blip. This will take place at a time of low activity this time, not peak activity.
Are there any best practices relating to this?
What would be the safest way to leave the databases online for most of the time (except the blip) and not have them failover multiple times?
Do I shut down the inactive node? Do I stop data movement?
We have 2 nodes running SQL 2016 Standard and 50 availability groups.
Any tips or ideas would be great.
Thank you very much
Best Answer
If you change the failover mode to "manual" then they should not failover automatically.