APA0876 (12/17/2012)
Hi,I'm wondering how can I avoid the SQL server Agent to start o SQL Server failover cluster. I changed the start mode to disabled but I haven't checked doing the failover. Will it work this way?
On the case of a SQL server stand alone should it be ok doing the same change. I know that changing the start mode to manual will work on an stand alone but it will be good to know on Failover.
Thanks!!!!!
APA
Failover cluster manager knows the state of each clustered resource. Manually stopping a clustered service should leave it offline until you restart it. The SQL Server service and its agent should be set to manual startup initially so that they fall under Failover cluster manager control. You could disable it but manually stopping it via the cluster admin tools would be better.
Incidentally, why don't you want the agent service to start, any particular reason?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉