Multi-site MSSQL Availability Group & Disaster Recovery
There is a lot of information scattered around different blogs and Microsoft documentation about running SQL Availability Groups across multiple sites for DR or reporting requirements, this post outlines how to get a 3 node cluster working again when you have to failover to your DR site. Assumptions: Failover …