Proper Shutdown of SQL Servers in a Cluster I was just wondering what the best approach should be for shutting down an Active/Active Cluster where both nodes need to be shutdown for disk maintenance.

I was thinking of this process:


Open Failover Cluster Manager
Right-click on the cluster name, select ‘More Actions’, then “Shut Down Cluster…”
When prompted if you are sure you want to shut down the cluster, click “Yes”
Shutdown both Nodes
Do Disk Maintenance
Power on both Nodes
Fail Cluster resources back to their preferred node


Does anyone see any issues with that? How do you ensure the Cluster Resources come back up on the correct node considering they'll come up at a different time?
Does anyone see any issues with that?


You are correct in the steps but your approach is way too much for a little work. 

For disk maintenance, why would you shutdown the entire cluster ?

Just suspend that disk (which requires maintenance) and then once it is done resume the node.

Basically, SHUT DOWN CLUSTER will stop all the roles and services on all the nodes of the cluster. The Cluster UI will ensure that all the roles and services are shutdown gracefully.

Seems like you have posted the same question at SQLServerCentral.com

Refer to How to Properly Shutdown a Failover Cluster or a Node