April 29, 2010 at 1:03 am
Hi,
We have server with Sql Server Cluster 2000 on windows server 2000 cluster machine.My question is when i keep the cluster service alone as Automatic start,then rest of the services (MS Sql server,SQL agent services) type as manual,will Cluster services start those services automatically when windows server rebooting ? is there any issues keep the Cluster , Ms sql server & Sql agent services as Automatic ? Please suggest me the best option.
Thanks in Advance.
April 29, 2010 at 6:07 am
I'm not quite sure I understand the question, but I'll try.
If you add SQL Services to the cluster administrator tool, you should absolutely make sure they are set to restart. If not, then you've just shot yourself in the foot. Why have a cluster for maintaining Server availability if you're not going to take advantage of it?
Some SQL Services (for 2005 & up) are not available as clustered services. SSIS is the one I'm thinking of off the top of my head, not sure about the other BI related ones. So you have to have this installed on each individual server (I believe. It's been a while since I've had to do this).
But if you can get away with it, absolutely have all your SQL Services set to restart upon failover. Otherwise, you'll be trying to troubleshoot problems with an unavailable server that aren't really problems.
BTW: Windows Cluster Administrator has an option for forcing the services to restart or not restart. Right click a service, go to properties, and I think it's the third tab over. This is where you set the cluster version of Automatic. In SQL Server Agent properties, make sure all Restart options are checked too. Lastly, when a cluster fails over, it stops all services. It has to. So if you don't have "Restart" chosen, all your services just stop and you can't get anything done.
April 29, 2010 at 6:09 am
The SQL Server Service and Agent Service should NOT be set to automatic- if so, on startup, those services will attempt to start on both nodes.
The Cluster Service should be automatic. SQL and Agent should be manual.
April 29, 2010 at 6:12 am
Just to clarify- I'm talking about the configuration in "services.msc". Post above mine is right on- all this configuration should be done in Cluster Administrator. Don't make changes in "services".
April 29, 2010 at 6:17 am
NJ-DBA (4/29/2010)
The SQL Server Service and Agent Service should NOT be set to automatic- if so, on startup, those services will attempt to start on both nodes.The Cluster Service should be automatic. SQL and Agent should be manual.
We've never had the problem of services trying to start up in both nodes. And we do have SQL Agent set up to restart when I go to SSMS.
EDIT: We also have it set up in Cluster Administrator too. But we're using SQL 2005.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply