4

My three node SQL Server 2008 R2 physical server cluster needs to be shutdown, moved along with its storage to a new location, and restarted once in the new location. My desire is to have a clean, controlled shutdown/startup sequence and, if possible, for all SQL Server instances to remain on their original node during this process. So, if SQLInstA is on NodeA and SQLInstB is on NodeB and NodeC is empty, there is no failover during server shutdown and I’ll bring up the services individually upon startup.

I’ve read various recommendations regarding setting SQL Server offline, pausing nodes, stopping cluster services, setup startup types to manual.

My first thought was to set the SQLInstA and SQLInstB services offline in Failover Cluster Manager. Offline does not trigger a failover so they’ll stay put. But, rebooting will cause failover, regardless of my setting them to have only one preferred owner. The service doesn’t restart, even though I didn’t “disable auto start”, so even if both instances ended up on the same node, the services would be down on startup, which isn’t horrible. Just manual failover work afterward.

I could stop the cluster services, but that triggers failover as well. Is it important to stop cluster services in this case?

Any thoughts on how to accomplish this?

6

Shutting down the cluster for a move is pretty straight forward.

  1. Open the failover cluster administrator.
  2. Using the failover cluster administrator stop the resource groups for the SQL instances
  3. Shut down two of the nodes.
  4. At this point the cluster will fail and the cluster service will stop.
  5. Shutdown the final node

To bring things back online.

  1. Startup all the servers.
  2. Start the cluster service if it didn't start automatically
  3. Verify that the servers can see the storage correctly.
  4. Startup the resource groups that host the SQL instances from within the Failover cluster administrator assigning them to the correct node of the cluster as you start them.

A word of advice, make sure that EVERY cable is properly labeled at both ends before you unplug anything. I've done this kind of move a few times. A couple of hours of labeling the cables will save you hours of pain when getting things back up and running.

  • Good point. I'm not allowed in the data center but I'll bring this up with my team. – SandraV Dec 2 '14 at 23:29
  • Thanks so much for the assist. I feel much better about my move plan now. Next up: mirrors – SandraV Dec 3 '14 at 1:26
  • Hi Denny, was wondering if my email got through? I sent it on 2014-12-08 at 17:49 if that helps you find it in your junk folder. – Jack Douglas Dec 30 '14 at 7:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.