• Always on Availability group between 2 separate SQL Clusters.

    From Query Builder@21:1/5 to All on Fri Sep 11 11:31:48 2015
    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..

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)