SQL Server Performance Forum – Threads Archive
Restart SQL ServiceWe have the following configuration.
-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,
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
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
Thank you Satya and Brad.