Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1940
| 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> (permalink) |
| Subject | Always on Availability group between 2 separate SQL Clusters. |
| From | Query Builder <querybuilder@gmail.com> |
| 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 |
Show key headers only | 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 comp.databases.ms-sqlserver | Previous | Next | Find similar
Always on Availability group between 2 separate SQL Clusters. Query Builder <querybuilder@gmail.com> - 2015-09-11 11:31 -0700
csiph-web