question

Heisenberg avatar image
0 Votes"
Heisenberg asked AlexBykovskyi answered

sql server cluster failover.

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.

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·
Heisenberg avatar image Heisenberg JeffreyWilliams-3310 ·

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

0 Votes 0 ·

1 Answer

AlexBykovskyi avatar image
0 Votes"
AlexBykovskyi answered

Hey,

Did you check the event log? The following article might help understanding failover policies for FCI:
https://docs.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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.