Mar 08 2022 08:03 AM
Is there way to set the fail over preference of the nodes in Always ON?
Example: Say I have a 4 node Always On Availability Group. Node 1A and Node 2A are in one data center and Node 1B and Node 2B are in another. I would like to set it so if Node 1A is the primary and fails it goes to 1B first then to 2A and 2B. Can this be done in SQL 2016 or SQL 2019?
Mar 12 2022 09:37 AM