Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.sqlserver.replication > #1
| X-Received | by 10.13.213.215 with SMTP id x206mr214797ywd.7.1441996232435; Fri, 11 Sep 2015 11:30:32 -0700 (PDT) |
|---|---|
| X-Received | by 10.50.92.7 with SMTP id ci7mr54827igb.4.1441996232377; Fri, 11 Sep 2015 11:30:32 -0700 (PDT) |
| Path | csiph.com!xmission!news.glorb.com!v79no411609qge.0!news-out.google.com!nt1ni7584igb.0!nntp.google.com!kq10no1072809igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
| Newsgroups | microsoft.public.sqlserver.replication |
| Date | Fri, 11 Sep 2015 11:30:31 -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 | <5de09afb-aef3-41a1-9470-d02ccdb4a4f3@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:30:32 +0000 |
| Content-Type | text/plain; charset=ISO-8859-1 |
| Content-Transfer-Encoding | quoted-printable |
| Xref | csiph.com microsoft.public.sqlserver.replication:1 |
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 microsoft.public.sqlserver.replication | Next | Find similar
Always On Availability Group between 2 separate SQL clusters Query Builder <querybuilder@gmail.com> - 2015-09-11 11:30 -0700
csiph-web