May 12, 2015 at 8:12 pm
Hi, our server are physically being moved to a new data center. There is a 7 node failover cluster running on these servers. Could anyone please suggest the process to shutdown this cluster group so that when the server comes back up there shouldn't be any problems regarding the cluster failovers. There are 21 instances on 6 of the nodes and one node is passive.
I came up with the following steps:
1. Shutdown the Passive Node.
2. Designate one of the nodes to move all the instances. Lets say node 1.
3. Move the instances of an active node to node 1 and shut down the active node.
4. Repeat step 3 for all the active nodes by moving the instances on these nodes to node 1 and shutting them down.
5. Once all the instances are on node 1 turn off the instances are shut down the node.
6. Turn off SQL server agent then the SQL server and cluster services.
alternatively:
1. Shutdown the Passive Node.
2. Designate one of the nodes to move all the instances. Lets say node 1.
3. Move the instances of an active node to node 1 and shut down the active node.
4. Turn off all the instances on Node 1.
5. Repeat step 3 and 4 for all the active nodes(moving the instances on these active nodes to Node 1, shutting the active node down and turning off the instances once they are running on Node 1).
6. Once all the nodes are turned off except for Node 1, turn off node 1.
Please let me know if I am on the right track or suggest the best process.
May 13, 2015 at 4:11 am
vrmutyala (5/12/2015)
There are 21 instances on 6 of the nodes and one node is passive.I came up with the following steps:
1. Shutdown the Passive Node.
Ok so far
vrmutyala (5/12/2015)
2. Designate one of the nodes to move all the instances. Lets say node 1.3. Move the instances of an active node to node 1 and shut down the active node.
All of the instances may not be installed across all of the nodes, in fact I'd recommend against.
vrmutyala (5/12/2015)
5. Once all the instances are on node 1 turn off the instances are shut down the node.
this is unnecessary
vrmutyala (5/12/2015)
6. Turn off SQL server agent then the SQL server and cluster services.
Stopping the sql server instance clustered resource will automatically stop it's agent due to the resource dependency.
I would
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 14, 2015 at 8:32 am
Thank You!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply