X-Received: by 10.13.239.197 with SMTP id y188mr249890ywe.0.1441996308101; Fri, 11 Sep 2015 11:31:48 -0700 (PDT) X-Received: by 10.182.142.226 with SMTP id rz2mr1960obb.8.1441996308069; Fri, 11 Sep 2015 11:31:48 -0700 (PDT) Path: csiph.com!optima2.xanadu-bbs.net!xanadu-bbs.net!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!z77no411954qge.1!news-out.google.com!nt1ni7584igb.0!nntp.google.com!kq10no1073637igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.ms-sqlserver Date: Fri, 11 Sep 2015 11:31:48 -0700 (PDT) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=70.208.73.190; posting-account=PgKd2woAAADMEPoOHlv-FZYtrlmqlSnd NNTP-Posting-Host: 70.208.73.190 User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <3db59f85-df0b-4c3c-bcbf-7882ed991d25@googlegroups.com> Subject: Always on Availability group between 2 separate SQL Clusters. From: Query Builder Injection-Date: Fri, 11 Sep 2015 18:31:48 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Lines: 13 Xref: csiph.com comp.databases.ms-sqlserver:1940 I have an active passive cluster on my primary Data center in NY and have a= DR Active / passive SQL Cluster in TX.=20 Both clusters host an active / passive SQL instance. Lets call it SQLNY(Pri= mary) 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 wil= l be able to run under any of the 4 nodes (2 in NY and 2 in TX based on sta= tus).=20 Is there a practical way to implement this? This will not only give me inst= ant fail over within the NY (Primary) but also give me the flexibility to f= ail over to TX.=20 I am using SQL 2014 Enterprise Edition on both clusters. Any help will be m= uch appreciated..