Monday, March 12, 2012

How to Reboot a Clustered SQL Server Agent


If I am running SQL Server 2005 in a clustered environment, what is the safest way to restart the SQL server agent? It is currently running but I need to restart it for maintenance purposes.

Is the safeway way to restart is to login to the SQL Server Management Studio as the system administrator, select the SQL Server Agent object, right-mouse click and select "Restart?"

When you stop agent, all running jobs will stop. This may not be what you want. Other than that, you can stop the service via services manager or enterprise mgr.

|||

if you run SQL 2005 in a cluster environment .

i think you would better to manage the program via "cluster administrator"

So if you want to stop/restart the services running in cluster .you could choose the "cluster administrator"

No comments:

Post a Comment