Groups > microsoft.public.sqlserver.replication > #1

Always On Availability Group between 2 separate SQL clusters

Newsgroups	microsoft.public.sqlserver.replication
Date	2015-09-11 11:30 -0700
Message-ID	<5de09afb-aef3-41a1-9470-d02ccdb4a4f3@googlegroups.com> (permalink)
Subject	Always On Availability Group between 2 separate SQL clusters
From	Query Builder <querybuilder@gmail.com>

Show all headers | View raw

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..

Back to microsoft.public.sqlserver.replication | Next | Find similar

Thread

Always On Availability Group between 2 separate SQL clusters Query Builder <querybuilder@gmail.com> - 2015-09-11 11:30 -0700

csiph-web