SQL Server Performance Forum – Threads Archive

Proper Way to bring down Cluster

Hi, What is the proper way to bring down a SQL Cluster running on a Windows Server 2003 cluster? We need to do this occasionaly and we always have problems bringing every thing back up cleanly. TIA,
Mike

---

Here is what we do, although I am sure there are other "proper" was. To bring down: 1) Be sure all users are off the cluster.
2) Assuming a 2-node cluster, move any active resources off node 2 onto node 1.
3) Bring down node 2 gracefully.
4) Brink down node 1 gracefully. To brin back up. 1) Bring up node 1.
2) Bring up node 2.
3) Move relevant resoures from node 1 to node 2.
What specific problems have you been experiencing? —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

---

]]>