Groups > microsoft.public.sqlserver.server > #18800

Re: Always On Availability between 2 separate SQL Clusters

Newsgroups	microsoft.public.sqlserver.server
Date	2017-08-22 08:31 -0700
References	<1ec58b2f-46c0-41d2-906e-391f6b435722@googlegroups.com>
Message-ID	<7fc1621d-cb60-4b19-a0ae-bdc2a9e082a6@googlegroups.com> (permalink)
Subject	Re: Always On Availability between 2 separate SQL Clusters
From	call2sqldba@gmail.com

Show all headers | View raw

On Saturday, September 12, 2015 at 12:00:07 AM UTC+5:30, Query Builder wrote:
> 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.server | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Always On Availability between 2 separate SQL Clusters Query Builder <querybuilder@gmail.com> - 2015-09-11 11:29 -0700
  Re: Always On Availability between 2 separate SQL Clusters call2sqldba@gmail.com - 2017-08-22 08:31 -0700
  Re: Always On Availability between 2 separate SQL Clusters call2sqldba@gmail.com - 2017-08-22 08:54 -0700

csiph-web