Post reply

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

  • 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.

  • 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.

  • April 29, 2020 at 6:25 pm

    #3747429

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply