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?

more ▼

asked Jul 06, 2011 at 10:49 AM in Default

avatar image

535 41 42 47

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Jul 06, 2011 at 11:00 AM

avatar image

4.9k 4 5

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?

Jul 06, 2011 at 11:45 AM srivivek

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.

Jul 06, 2011 at 12:10 PM SirSQL
(comments are locked)
10|1200 characters needed characters left

Startup mode should always be manual,you dont get oprion of automatic startup while installation too.

more ▼

answered Jul 06, 2011 at 12:21 PM

avatar image


(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 06, 2011 at 10:49 AM

Seen: 1937 times

Last Updated: May 17, 2013 at 02:06 AM

Copyright 2018 Redgate Software. Privacy Policy