January 19, 2010 at 11:52 am
Hi,
We have SQL Server 2005 EE x64 with SP3 on Active/Passive clustere. Currently, we have set the SQL Services to start Automatically. But I read somewhere and also talking to one of the DBAs, I came to know that on Cluster, we should keep SQL Services to start manually from SQL Server configuration manager.
Question:
Does it required to have SQL Services start mode set manual in a clustered environment? If yes, could you please tell me the reason.
Thanks
January 19, 2010 at 12:02 pm
gmamata7 (1/19/2010)
Hi,We have SQL Server 2005 EE x64 with SP3 on Active/Passive clustere. Currently, we have set the SQL Services to start Automatically. But I read somewhere and also talking to one of the DBAs, I came to know that on Cluster, we should keep SQL Services to start manually from SQL Server configuration manager.
Question:
Does it required to have SQL Services start mode set manual in a clustered environment? If yes, could you please tell me the reason.
Thanks
No it is not required. However, if it is set to auto, you will need to set the service to be dependent on other cluster resources that are required to be started before SQL can start.
Setting it to manual adds an extra step for you to do when rebooting the server - gives you a little more control.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply