Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ciran_patil@yahoo.com
Starting Member
17 Posts |
 Posted - 2008-10-28 : 17:46:10
|
| Hi All,I am just wondering about SQL services behaviour during Cluster failover. Does these SQL services gets restarted during failover ?If SQL services are getting restart then whats the use of having SQL cluster?Please share your views and experiance.ThanksKiranThanksKiran Patil |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-28 : 17:54:54
|
| If you are having 2 node active/passive cluster, you failover node will connect to SQL server and own resources during failover . |
 |
|
|
ciran_patil@yahoo.com
Starting Member
17 Posts |
Posted - 2008-10-28 : 17:59:44
|
| Right, considering I have 2 node active/passive cluster. Lets say If I have got 5 SQL Jobs running on active node and I failover from active to passive node then will these 5 running jobs be stopped or still running even after failover?Thanks KiranThanksKiran Patil |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-28 : 18:07:02
|
| http://technet.microsoft.com/en-us/magazine/cc137997.aspx |
|
|
|
ciran_patil@yahoo.com
Starting Member
17 Posts |
Posted - 2008-10-29 : 10:43:14
|
| Thanks Sodeep.I read the link, still could not undesrstand, if the running jobs will stop or keep running when we do failover. Could you please answer this? ThanksThanksKiran Patil |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2008-10-29 : 13:23:32
|
| Running jobs will stop and will need to be restarted manually after the failover.Failover stops the SQL service (and Agent) to move it to one of the other nodes in the cluster. Once moved to another node, it starts back up (SQL Service & Agent).Your friendly High-Tech Janitor:http://grayburn.wordpress.com |
|
|
|
ciran_patil@yahoo.com
Starting Member
17 Posts |
Posted - 2008-10-29 : 15:35:07
|
| Right, Thank you.Is there any way to avoid this. I mean is there an option to keep these jobs running or restarting them auomatically after failover from the steps they were stopped during failover?ThanksKiran Patil |
|
|
|
Haywood
Posting Yak Master
221 Posts |
|
|
ciran_patil@yahoo.com
Starting Member
17 Posts |
Posted - 2008-10-29 : 17:55:44
|
| Thank YouThanksKiran Patil |
|
|
|
|
|
|
Does SQL services gets restarted during failover