• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1100
  • Last Modified:

proper shutdown of MS SQL cluster

Hello,

I need help with the proper shut down procedure for a MS SQL cluster. Operating system is 2003 Server Enterprise, and the Enterprise Manager for SQL server says 8.0

Is there a "best practice" method for shutting down both nodes of the cluster?

Thank you,
0
vg30e
Asked:
vg30e
  • 2
1 Solution
 
PberSolutions ArchitectCommented:
We let the cluster service do all the work.  We rarely ever use enterprise manager to shutdown SQL.

If I want to shutdown both nodes, I will usually shutdown the offline node, then shutdown the online node.  I mention usually since sometimes I will fail over to the other node first to make sure there are no issues with the cluster servce.  But I always shutdown the offfline node first, then the online.  We never manually shutdown SQL.
0
 
vg30eAuthor Commented:
so you just stop the cluster service on one node , then the other, and, let mscs manager shut everything down for you?
0
 
PberSolutions ArchitectCommented:
Yup, that's it.  We've been running several SQL cluster for around 5 years now and that how we do it every time.
With Clustering, it best to let the cluster service control things.  
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now