October 22, 2014 at 12:58 am
We are looking to setup an AlwaysOn A/G between two SQL instances across two SQL clusters - one cluster has two nodes the other has three nodes.
Is this possible using WSFC? Does the A/G wizard just handle this?
October 22, 2014 at 4:58 am
shindle 17293 (10/22/2014)
We are looking to setup an AlwaysOn A/G between two SQL instances across two SQL clusters - one cluster has two nodes the other has three nodes.
Firstly, it's not a SQL cluster it's a Windows cluster, SQL server is just a clustered application sitting on top of this.
shindle 17293 (10/22/2014)
Is this possible using WSFC? Does the A/G wizard just handle this?
This is only supported for migration purposes and not a permanent solution. Creating an AlwaysOn group will create a clustered role which cannot be moved between separate Windows Server Failover Cluster environments.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2014 at 7:45 pm
Point taken re: first comment. We are looking to setup an A/G Group between two clustered SQL instances.
So this is not really supported?
October 23, 2014 at 4:20 am
shindle 17293 (10/22/2014)
Point taken re: first comment.
Once you understand the first comment the rest gets easy 😉
To re cap, An AlwaysOn Availability group across 2 Failover Cluster Instances of SQL Server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply