February 19, 2014 at 6:19 pm
Just curious- can/should sql server service restart on cluster trigger failover to another node? Thanks
February 19, 2014 at 7:09 pm
YES, SQL server gets restarted when you failover to the other node.
February 19, 2014 at 8:57 pm
Thanks for your response but actually my question was quite different, sorry:-)- if I restart sql server service on currently active node #1 will it trigger automatic failover to passive node #2?
February 20, 2014 at 2:09 am
Yuri55 (2/19/2014)
Thanks for your response but actually my question was quite different, sorry:-)- if I restart sql server service on currently active node #1 will it trigger automatic failover to passive node #2?
No it should not, is that the behaviour you are seeing?
does it happen each time?
does it happen on only one node?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 20, 2014 at 6:17 am
Thanks Perry-
no, it (failover) did not happen yet 🙂
We recently moved standalone server to cluster one but on Active node put Service Start Mode to Automatic one (probably- inertia, i.e. as for standalone sql server). I need to change it to Manual one (as recommended) and in case Service restarts (after Start Mode change- frankly not sure it will happen 🙂 need to be sure Failover will not be triggered. Cannot risk- Prod server.
Therefore digging ahead.
February 20, 2014 at 6:27 am
Yuri55 (2/20/2014)
Thanks Perry-no, it (failover) did not happen yet 🙂
We recently moved standalone server to cluster one but on Active node put Service Start Mode to Automatic one (probably- inertia, i.e. as for standalone sql server). I need to change it to Manual one (as recommended) and in case Service restarts (after Start Mode change- frankly not sure it will happen 🙂 need to be sure Failover will not be triggered. Cannot risk- Prod server.
Therefore digging ahead.
For clustered sql server installations, the services on each node should be set to manual. You do not want the service(s) trying to start outside of the control of the failover cluster manager!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 24, 2014 at 4:31 am
If you want to stop or start SQL Services on a Cluster, you should use the Cluster Manager to put the resource group On or Off. If you do this at a SSMS or Service Applet then you may not get the result you want.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 24, 2014 at 10:48 am
Yes, you need to make the service start up to be manual. In case of manual restart, just take the resource offline and then bring it back on line. This doesn't cause failover.
However you should have some alerts set up to let you know if the SQL server goes down.
--
SQLBuddy
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply