home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 19,211 of 19,505   
   Query Builder to All   
   Always on Availability group between 2 s   
   11 Sep 15 11:31:48   
   
   From: querybuilder@gmail.com   
      
   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..   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca