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

How do I restart SQL Service service on a cluster without failing over?

I just need to restart the SQL service on the primary node, but I don't want to fail it over to the second; it is an active/passive cluster. I'm getting mixed answers, one telling me that I can do it through computer management services and others telling me never to stop and start services there, but only through cluster administrator. Can someone please help out ASAP? Thank you.
0
itagent007
Asked:
itagent007
  • 2
  • 2
1 Solution
 
oBdACommented:
NEVER use the Services MMC to stop or restart any service that is a cluster resource; the cluster service will consider it a service failure and do a failover.
The proper way is indeed to use the Cluster MMC; take the SQL server resource offline, then bring it back online again.
0
 
itagent007Author Commented:
Sorry for the clarification, but if I take the resource offline through Cluster MMC and bring online, this essentially restarts the service without failing over?
0
 
oBdACommented:
Yes; when you take a service resource offline, the service is stopped (you can check that in the services MMC). As you may have noticed, the startup type of any service that is a cluster resource is set to manual, as the cluster decides whether the service needs to be started or stopped.
0
 
itagent007Author Commented:
Cool, thanks for the help.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

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