Restart SQL Service | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Restart SQL Service

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
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.
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
Thank you Satya and Brad.
]]>