Query Builder
2015-09-11 18:29:58 UTC
I have an active passive cluster on my primary Data center in NY and have a DR Active / passive SQL Cluster in TX.
Both clusters host an active / passive SQL instance. Lets call it SQLNY(Primary) and SQLTX (DR). I want to enable always On Availability group within the two SQL Instances SQLNY and SQLTX. The listener will be SQLAG. This will be able to run under any of the 4 nodes (2 in NY and 2 in TX based on status).
Is there a practical way to implement this? This will not only give me instant fail over within the NY (Primary) but also give me the flexibility to fail over to TX.
I am using SQL 2014 Enterprise Edition on both clusters. Any help will be much appreciated..
Both clusters host an active / passive SQL instance. Lets call it SQLNY(Primary) and SQLTX (DR). I want to enable always On Availability group within the two SQL Instances SQLNY and SQLTX. The listener will be SQLAG. This will be able to run under any of the 4 nodes (2 in NY and 2 in TX based on status).
Is there a practical way to implement this? This will not only give me instant fail over within the NY (Primary) but also give me the flexibility to fail over to TX.
I am using SQL 2014 Enterprise Edition on both clusters. Any help will be much appreciated..