SQL Cluster

  • I have four node active-active cluster.

    Let's say I have two servers A11,A12,A21,A22 and they need to own their own nodes in order not to have resource issue.

    E.g : Node A11 should be on A11

    Node A12 should be on A12,

    Node A21 should be on A21.

    Node A22 should be on A22.

    A11 and A21 failed over to A21.

    How can I determine which node they actually need to be in order to failover?

  • I believe you need to go to properties of each node (Failover cluster manager => Services and applications => Right click each instance => Properties), from the server properties check preferred owners (check only the node you want the service to run under), then click failover next to general tab and select allow failback immediately. This allows the service to run on the preferred owner as soon it fails back when a failover occurred.

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

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