I want to create 3 nodes availability group on SQL Server 2016.
- Node 1 and Node 2 is my primary server and stays in primary data center. Each nodes set to readable secondary replica.
- Node 3 stays in DR Data Center. I wanna use node 3 when servers in primary data center (node 1 and node 2) are down.
How can I set up this configuration? Should I use 2 quorum disks and uncheck the server in preferred owners (in WSFC configuration)?