SQL Services restarted?

Question

SQL Services restarted?

SQL ORACLE

One Orange Chip

Points: 27807
More actions
August 4, 2011 at 2:56 pm

#255309

In a cluster, if we reboot one node, is the SQL Server sercives restarted?
I guess not, any other opinion?
Many thanks in advance.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

If it's the active node you're rebooting, yes.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

@SQLFRNDZ SSCrazy Eights Points: 9095 More actions · Answer 2

SQL ORACLE (8/4/2011)
is the SQL Server sercives restarted?
I guess not, any other opinion?
Many thanks in advance.

Even if is clustered or not if you restart the server the services should be dependent on service property

"Manual/Automatic" start service on restart.

Run---> Services-->Select Service--Double cliick...

[font="Tahoma"]
--SQLFRNDZ[/url]
[/font]

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 3

SQL ORACLE

One Orange Chip

Points: 27807

August 4, 2011 at 8:35 pm

#1364067

@SQLFRNDZ

I cannot get your point.

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 4

GilaMonster (8/4/2011)
If it's the active node you're rebooting, yes.

If so, any running job will be killed?

spaghettidba SSC Guru Points: 105732 More actions · Answer 5

SQL ORACLE (8/4/2011)
GilaMonster (8/4/2011)
If it's the active node you're rebooting, yes.
If so, any running job will be killed?

Sure.

-- Gianluca Sartori

BudaCli Hall of Fame Points: 3384 More actions · Answer 6

SQL ORACLE (8/4/2011)
GilaMonster (8/4/2011)
If it's the active node you're rebooting, yes.
If so, any running job will be killed?

Couldn't agree with you more about @SQLFRNDZ's comment, and why would you want to [start\stop] SQL services within a cluster using windows services?

From what I understand if you do([start\stop] services not within cluster) it like this your cluster isn't going to function properly.

What you don't know won't hurt you but what you know will make you plan to know better

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

duda (8/5/2011)
Couldn't agree with you more about @SQLFRNDZ's comment, and why would you want to [start\stop] SQL services within a cluster using windows services?
From what I understand if you do([start\stop] services not within cluster) it like this your cluster isn't going to function properly.

This isn't about manually stopping a service. The question was, if a node of the cluster is rebooted, will the SQL service stop and restart as a result of that reboot.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

SQL ORACLE (8/4/2011)
GilaMonster (8/4/2011)
If it's the active node you're rebooting, yes.
If so, any running job will be killed?

All connections will be dropped, all open transactions roll back. Once the SQL service on the active node as stopped, the cluster admin will start it up on the other node. Jobs will have to be restarted and applications will have to reconnect.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass