nodes in cluster

  • what are possible and preferred owners in cluster ?

  • Possible is all the nodes that are capable of running the SQL Server instance, preferred is the one node where you'd like it to be running under ideal conditions.

    I think there's some threads about this topic already on SSC:

    http://www.sqlservercentral.com/Forums/Topic1174454-146-1.aspx

    There's a number of free resources available discussing SQL Server with clusters, one of my favorite is:

    https://www.brentozar.com/sql/sql-server-failover-cluster/

  • ramyours2003 (10/17/2016)


    what are possible and preferred owners in cluster ?

    The possible node property applies to each and every cluster resource with a cluster role\group, this dictates on which nodes the resource may be brought online.

    The Preferred owner property applies to the cluster role\group only and is used by the cluster service to direct the failover of a role\group. This is not as straight forward as you might think and it's used differently depending on what you are doing.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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