May 9, 2017 at 3:53 am
Stopped SQL service from Configuration manager in a cluster, is the failover supposed to happen?
Will stopping SQL Server resource or the role from one node in cluster failover manager will initiate a failover?
May 9, 2017 at 7:18 am
Hi, Stopped SQL service from Configuration manager in a cluster, is the failover supposed to happen?
A: You should always use FCM (Failover Cluster Manager) to stop clustered services (roles). My guess is, if you stop the services in Config manager, a failover would not occur and act the same as if you used FCM, hopefully.
Will stopping SQL Server resource or the role from one node in cluster failover manager will initiate a failover?
A: No, simply stopping the role will only stop the services and should not initiate a failover.
May 9, 2017 at 7:54 am
Will depend on the dependancies within the cluster. If that service is high in the dependency list which I would hope it is, then the failure or stopping of the service could be seen as serious enough to force the failover.
RVSC48 is right though this sort of thing should be done from within the Cluster Management console.
May 9, 2017 at 8:01 am
Hang on should have read that fully. So you stopped the SQL Service ? did you confirm which node was Active at the time you did this ? stopping the SQL Service on an Active node will always generate a failover if you have a clustered SQL Instance.
May 10, 2017 at 3:19 am
RandomEvent - Tuesday, May 9, 2017 8:01 AMHang on should have read that fully. So you stopped the SQL Service ? did you confirm which node was Active at the time you did this ? stopping the SQL Service on an Active node will always generate a failover if you have a clustered SQL Instance.
You can stop service only on active node as the service is already in stopped state at passive node.
May 10, 2017 at 3:20 am
RVSC48 - Tuesday, May 9, 2017 7:18 AMHi, Stopped SQL service from Configuration manager in a cluster, is the failover supposed to happen?
A: You should always use FCM (Failover Cluster Manager) to stop clustered services (roles). My guess is, if you stop the services in Config manager, a failover would not occur and act the same as if you used FCM, hopefully.
Will stopping SQL Server resource or the role from one node in cluster failover manager will initiate a failover?
A: No, simply stopping the role will only stop the services and should not initiate a failover.
Thanks RVSC48,
So only scenario where the failover occurs is when the whole server is down?
May 10, 2017 at 7:34 am
So only scenario where the failover occurs is when the whole server is down?
A: I wouldn't say only. You can always manually failover, but, for automatic failovers, it's usually some issue at the OS level on the node that can trigger a failover. There have been many times that you have to scan the event logs on the nodes and review the cluster manager log to determine the reason for an auto failover. And of course, with a cluster, your single point of failure for a cluster is your storage due to (if) being shared.
May 11, 2017 at 12:02 am
RVSC48 - Wednesday, May 10, 2017 7:34 AMSo only scenario where the failover occurs is when the whole server is down?
A: I wouldn't say only. You can always manually failover, but, for automatic failovers, it's usually some issue at the OS level on the node that can trigger a failover. There have been many times that you have to scan the event logs on the nodes and review the cluster manager log to determine the reason for an auto failover. And of course, with a cluster, your single point of failure for a cluster is your storage due to (if) being shared.
Thanks again RVSC48
May 11, 2017 at 7:13 am
Rechana Rajan - Tuesday, May 9, 2017 3:53 AMStopped SQL service from Configuration manager in a cluster, is the failover supposed to happen?Will stopping SQL Server resource or the role from one node in cluster failover manager will initiate a failover?
Out of the box, stopping the clustered sql server service from either FCM or SSCM will not initiate a failover.
Can you provide more detail on the failover policy configuration from the cluster group and its resources please, have they been changed?
Check your sql server error log and the cluster events for more information too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2017 at 3:45 am
Perry Whittle - Thursday, May 11, 2017 7:13 AMRechana Rajan - Tuesday, May 9, 2017 3:53 AMStopped SQL service from Configuration manager in a cluster, is the failover supposed to happen?Will stopping SQL Server resource or the role from one node in cluster failover manager will initiate a failover?
Out of the box, stopping the clustered sql server service from either FCM or SSCM will not initiate a failover.
Can you provide more detail on the failover policy configuration from the cluster group and its resources please, have they been changed?
Check your sql server error log and the cluster events for more information too
Thanks Perry.
I have changed the policy in FCM
If Resource Fails,attempt restart on current node- to 1 minute and I turned off the SQL Service from SQL Configuration Manager to Test whether it will come online after 1 min but it didn't.
June 7, 2017 at 4:05 am
Rechana Rajan - Wednesday, June 7, 2017 3:45 AMPerry Whittle - Thursday, May 11, 2017 7:13 AMRechana Rajan - Tuesday, May 9, 2017 3:53 AMStopped SQL service from Configuration manager in a cluster, is the failover supposed to happen?Will stopping SQL Server resource or the role from one node in cluster failover manager will initiate a failover?
Out of the box, stopping the clustered sql server service from either FCM or SSCM will not initiate a failover.
Can you provide more detail on the failover policy configuration from the cluster group and its resources please, have they been changed?
Check your sql server error log and the cluster events for more information tooThanks Perry.
I have changed the policy in FCM
If Resource Fails,attempt restart on current node- to 1 minute and I turned off the SQL Service from SQL Configuration Manager to Test whether it will come online after 1 min but it didn't.
stopping a clustered instance of sql server is supported either via FCM or SCM, it is not supported via services.msc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2017 at 8:12 am
Thanks perry
Rechana Rajan - Wednesday, June 7, 2017 3:45 AMPerry Whittle - Thursday, May 11, 2017 7:13 AMRechana Rajan - Tuesday, May 9, 2017 3:53 AMStopped SQL service from Configuration manager in a cluster, is the failover supposed to happen?Will stopping SQL Server resource or the role from one node in cluster failover manager will initiate a failover?
Out of the box, stopping the clustered sql server service from either FCM or SSCM will not initiate a failover.
Can you provide more detail on the failover policy configuration from the cluster group and its resources please, have they been changed?
Check your sql server error log and the cluster events for more information tooThanks Perry.
I have changed the policy in FCM
If Resource Fails,attempt restart on current node- to 1 minute and I turned off the SQL Service from SQL Configuration Manager to Test whether it will come online after 1 min but it didn't.
stopping a clustered instance of sql server is supported either via FCM or SCM, it is not supported via services.msc
[/quote]
Thanks Perry.
As I mentioned earlier I did it from SCM
June 7, 2017 at 10:03 am
Rechana Rajan - Wednesday, June 7, 2017 8:12 AMThanks perryPerry Whittle - Wednesday, June 7, 2017 4:05 AMRechana Rajan - Wednesday, June 7, 2017 3:45 AMPerry Whittle - Thursday, May 11, 2017 7:13 AMRechana Rajan - Tuesday, May 9, 2017 3:53 AMStopped SQL service from Configuration manager in a cluster, is the failover supposed to happen?Will stopping SQL Server resource or the role from one node in cluster failover manager will initiate a failover?
Out of the box, stopping the clustered sql server service from either FCM or SSCM will not initiate a failover.
Can you provide more detail on the failover policy configuration from the cluster group and its resources please, have they been changed?
Check your sql server error log and the cluster events for more information tooThanks Perry.
I have changed the policy in FCM
If Resource Fails,attempt restart on current node- to 1 minute and I turned off the SQL Service from SQL Configuration Manager to Test whether it will come online after 1 min but it didn't.stopping a clustered instance of sql server is supported either via FCM or SCM, it is not supported via services.msc
Thanks Perry.
As I mentioned earlier I did it from SCM
[/quote]
Should be fine then
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 8, 2017 at 2:43 am
Perry Whittle - Wednesday, June 7, 2017 10:03 AMRechana Rajan - Wednesday, June 7, 2017 8:12 AMThanks perryPerry Whittle - Wednesday, June 7, 2017 4:05 AMRechana Rajan - Wednesday, June 7, 2017 3:45 AMPerry Whittle - Thursday, May 11, 2017 7:13 AMRechana Rajan - Tuesday, May 9, 2017 3:53 AMStopped SQL service from Configuration manager in a cluster, is the failover supposed to happen?Will stopping SQL Server resource or the role from one node in cluster failover manager will initiate a failover?
Out of the box, stopping the clustered sql server service from either FCM or SSCM will not initiate a failover.
Can you provide more detail on the failover policy configuration from the cluster group and its resources please, have they been changed?
Check your sql server error log and the cluster events for more information tooThanks Perry.
I have changed the policy in FCM
If Resource Fails,attempt restart on current node- to 1 minute and I turned off the SQL Service from SQL Configuration Manager to Test whether it will come online after 1 min but it didn't.stopping a clustered instance of sql server is supported either via FCM or SCM, it is not supported via services.msc
Thanks Perry.
As I mentioned earlier I did it from SCM
Should be fine then[/quote]
Thanks Perry.
If I do simulate failure from FCM it comes online immediately in same node,but if i stop SQL service from SQL Server Configuration manager it wont come online after 1 minute nor its doing a failover.
June 8, 2017 at 3:24 am
Rechana Rajan - Thursday, June 8, 2017 2:43 AMPerry Whittle - Wednesday, June 7, 2017 10:03 AMRechana Rajan - Wednesday, June 7, 2017 8:12 AMThanks perryPerry Whittle - Wednesday, June 7, 2017 4:05 AMRechana Rajan - Wednesday, June 7, 2017 3:45 AMPerry Whittle - Thursday, May 11, 2017 7:13 AMRechana Rajan - Tuesday, May 9, 2017 3:53 AMStopped SQL service from Configuration manager in a cluster, is the failover supposed to happen?Will stopping SQL Server resource or the role from one node in cluster failover manager will initiate a failover?
Out of the box, stopping the clustered sql server service from either FCM or SSCM will not initiate a failover.
Can you provide more detail on the failover policy configuration from the cluster group and its resources please, have they been changed?
Check your sql server error log and the cluster events for more information tooThanks Perry.
I have changed the policy in FCM
If Resource Fails,attempt restart on current node- to 1 minute and I turned off the SQL Service from SQL Configuration Manager to Test whether it will come online after 1 min but it didn't.stopping a clustered instance of sql server is supported either via FCM or SCM, it is not supported via services.msc
Thanks Perry.
As I mentioned earlier I did it from SCM
Should be fine then
Thanks Perry.
If I do simulate failure from FCM it comes online immediately in same node,but if i stop SQL service from SQL Server Configuration manager it wont come online after 1 minute nor its doing a failover.[/quote]
What policy settings do you have set for the group and the network name resource
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 1 through 15 (of 21 total)
You must be logged in to reply to this topic. Login to reply