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.