SQL Server Performance

Restart SQL Service

Discussion in 'SQL Server Clustering' started by gopal, Apr 27, 2004.

  1. gopal Member

    We have the following configuration.
    -Active/Passive Clustering
    -SQL Server 2000

    We want to restart the SQL Service without failover to the other node. Is it possible to restart the sql service using cluster administrator?

    Thanks,
    Gopal
  2. satya Moderator

    Use the Service Control Manager to start or stop a clustered instance of SQL Server. You cannot pause a clustered instance of SQL Server.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. bradmcgehee New Member

    Both the Service Control Manager, and Cluster Administrator, can be used to stop and start SQL Server services. Generally, I use Cluster Adminstrator. So, the answer to your question, is that you can restart the SQL Server services without failing over using Cluster Administrator.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  4. gopal Member

    Thank you Satya and Brad.

Share This Page