March 13, 2012 at 8:22 am
A decision was made to change the naming convention in our SQL Cluster environment and I am trying to change the individual node names without taking everything down. I am unsure of the order and hoping for some input.
March 13, 2012 at 8:27 am
Sorry, rest of my post did not post. My proposed plan was to:
Remove SQL from the first node on whose name I am changing.
Evict node from Cluster
Change node name
Add back into Windows Cluster
Add node back into SQL
I know it seems like a simple thing, but that is what I am concerned about and this is a production machine, albeit non-critical production, but production nonetheless. Thanks for any direction or pointing out any steps I should watch out for.
March 13, 2012 at 12:33 pm
christopher.waggoner (3/13/2012)
Sorry, rest of my post did not post. My proposed plan was to:Remove SQL from the first node on whose name I am changing.
Evict node from Cluster
Change node name
Add back into Windows Cluster
Add node back into SQL
I know it seems like a simple thing, but that is what I am concerned about and this is a production machine, albeit non-critical production, but production nonetheless. Thanks for any direction or pointing out any steps I should watch out for.
That's correct, obviously while the node is out you'll have no redundancy though, unless you have more than 2 nodes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply