sql server cluster failover.

Question

sql server cluster failover.

Heisenberg 261

One of our sql server instance services after failover didnt start automatically after failover. We have 2 new SQL server FCI. We have to start SQL Service manually on one of the node and then bring the SQL Server resource online in cluster manager. Ideally SQL Server resource should failover automatically and started automatically. Any help / pointer to sort this out will be great.

Jeffrey Williams 1,896 Reputation points

2021-07-22T19:58:12.82+00:00

This doesn't make sense - the correct configuration for services in an FCI cluster is to be set to manual startup. When the cluster fails over - the cluster starts the services on the new node. You should never have to start the services and then bring the resource online in the cluster manager. If the cluster cannot start the service/resource - it would fail and generate an event in the cluster log.
Heisenberg 261 Reputation points

2021-07-23T16:10:06.677+00:00

I agree, but thats what i want to find out, what is that setting that is missing to not failover automatically.

1 answer

Your answer

Jeffrey Williams 1,896 Reputation points

2021-07-22T19:58:12.82+00:00

This doesn't make sense - the correct configuration for services in an FCI cluster is to be set to manual startup. When the cluster fails over - the cluster starts the services on the new node. You should never have to start the services and then bring the resource online in the cluster manager. If the cluster cannot start the service/resource - it would fail and generate an event in the cluster log.
Heisenberg 261 Reputation points

2021-07-23T16:10:06.677+00:00

I agree, but thats what i want to find out, what is that setting that is missing to not failover automatically.

Answer 1

Hey,

Did you check the event log? The following article might help understanding failover policies for FCI:
https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/failover-policy-for-failover-cluster-instances?view=sql-server-ver15

In addition, you should have quorum configured for 2 node cluster. The following guide should help:
https://www.starwindsoftware.com/resource-library/starwind-virtual-san-installing-and-configuring-sql-server-2019-tp-failover-cluster-instance-on-windows-server-2016/

Cheers,

Alex Bykovskyi

StarWind Software

Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

Share via

sql server cluster failover.

1 answer

Your answer