Hi,
I have a Lab containing:
2 Hosts
2 SQL VMs (1 VM per Hots)
2 Domain controllers (1 DC per host)
I created a Windows Failover Cluster with those 2 SQL VMs to install SQL Availability Group.
As witness, and cause SQL AG don't need shared storage, I created a shared folder. This folder is located in the 1st DC.
Now, I'm imagining disaster scenario: 1st DC fails. The witness folder will not be available, so SQL AG will not work correctly.
I think about creating a second windows failover with 2 DCs with a kind of shared storage between two hosts. Is there a technical solution for this?
Thank you.