x

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

srivivek gravatar image

srivivek
519 41 42 43

(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

SirSQL gravatar image

SirSQL
4.8k 1 3

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

prakskarry gravatar image

prakskarry
11

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x91
x2
x2

asked: Jul 06, 2011 at 10:49 AM

Seen: 1551 times

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