question

srivivek avatar image
srivivek asked

SQL Start Mode in Cluster

This question is related to a SQL server with two node Active/Active cluster with two instances on it, What is the best practice for the SQL Start Mode Automatic/Manual?Should it be same on all the nodes and instances?
clusterstartmode
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
SirSQL avatar image
SirSQL answered
SQL Server and SQL Agent services should always be set to manual when running in a cluster. The cluster will handle bringing resources online on the specific node. By default when performing a clustered install this will be set to manual so you should not have to do anything further.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

srivivek avatar image srivivek commented ·
Thanks for the reply, what about if my instances are on Node1 and for some reason sql services on Node2 are stopped which are in manual mode, In this case what will happen if my Node1 crashes?
0 Likes 0 ·
SirSQL avatar image SirSQL commented ·
SQL will be managed by the cluster, so should the services fail, or a server go down then it would automatically failover to the other node and the services would start up there.
0 Likes 0 ·
prakskarry avatar image
prakskarry answered
Startup mode should always be manual,you dont get oprion of automatic startup while installation too.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.