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

  • SQLRocker

    SSCrazy

    Points: 2212

    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: 80378

    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: 2212

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

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

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