April 28, 2014 at 2:36 pm
I have an A & B node set up and running. I now want to add a C NODE.
The catch is the C NODE is in a SQL Cluster Environment.
I am guessing I add the Virtual Name of the C node to the current Always ON Cluster?
I tried adding it...the error message says" the Virtual Node is really the A node and to add the A NODE"?
Thanks
April 29, 2014 at 3:42 am
456789psw (4/28/2014)
I have an A & B node set up and running. I now want to add a C NODE.The catch is the C NODE is in a SQL Cluster Environment.
If i read this correct the node C you wish to use is already a member of another Windows cluster?
If so, you cannot join to the same clustyer as node a and b
456789psw (4/28/2014)
I am guessing I add the Virtual Name of the C node to the current Always ON Cluster?
No, the node name is used to join to a cluster, The sql instance virtual network name is used to join an availability group. See my guide at these links
AlwaysOn groups and FCIs part 1[/url]
AlwaysOn groups and FCIs part 2[/url]
AlwaysOn groups and FCIs part 3[/url]
456789psw (4/28/2014)
I tried adding it...the error message says" the Virtual Node is really the A node and to add the A NODE"?Thanks
see my top comment
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 7:09 am
Sounds I like I need to break the C node down to a stand alone server and then add the node to the ALWAYS ON cluster.
April 29, 2014 at 8:28 am
456789psw (4/29/2014)
Sounds I like I need to break the C node down to a stand alone server and then add the node to the ALWAYS ON cluster.
How many nodes in the cluster that node c is a part of. Removing node c from that cluster will remove it from the clustered instance membership
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 8:43 am
yes...the C node is a 2 node cluster. so I will need to blow it up so that it is no longer a cluster.
Take one of the servers make it the c node.
Then make it a part of a three node cluster for always on.
April 29, 2014 at 9:05 am
Before you destroy the cluster and the instance don't forget to backup any objects you may want
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 29, 2014 at 9:13 am
Thanks for the help!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply