How not to have sql to restart on the same node but failover on 1st failure in a

• SQLRocker

  SSCrazy

  Points: 2217

  More actions

  April 7, 2020 at 2:22 am

  #3740938

  Hi,

  By default sql tries to restart on the same node in case of a failure, next it does failover.

  Personally I am good with the default behavior , but I am being asked a interesting question - is it possible to have sql NOT try a restart on the same node and just failover in case of a failure?

  And where is it done from, is it this:

  In cluadmin-SQL Server Properties-Policies-

  There is a option

  1. Max restarts in the specified period - Will making it zero do the needful?

  Or there is some other way? Thanks.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  April 8, 2020 at 3:10 am

  #3741274

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• SQLRocker

  SSCrazy

  Points: 2217

  More actions

  April 29, 2020 at 6:25 pm

  #3747429

  Tested it - It works exactly as i guessed, making it 0 does the needful.