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

Posted on 2006-05-21
Last Modified: 2010-04-13
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.
Question by:itagent007
    LVL 82

    Expert Comment

    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.
    LVL 1

    Author Comment

    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?
    LVL 82

    Accepted Solution

    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.
    LVL 1

    Author Comment

    Cool, thanks for the help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now