Post reply

Failover cluster not working properly?

  • October 27, 2008 at 11:39 pm

    #192775

    hi all,

    we have 3 node cluster setup active/active/pasive for sql server 2005.

    node 1-> Active has one instance INS1

    node 2-> Passive

    node 3-> Active has 3 instances..INS2,INS3,INS4

    1. If node 1 shutdown,it is failover to node 2 and when node 1 is up,it(INS1) going back to node1 from node2(which is fine)

    2. If node3 is shutdown,it(INS2,INS3,INS4) is failover to node 2 but when node 3 is up,it(INS2,INS3,INS4) is not failover back to the node 3.

    Could you plz tell me what configuration options I need to check inordered to work the failover properly between node3 and node2?

    Thank You

    Madhu

  • October 28, 2008 at 9:21 am

    #890718

    Make sure that Node 3 is the preferred owner for INS2, INS3, and INS4 in Cluster administrator, also make sure that you have the failback option enabled.

    Hope that helps

  • October 28, 2008 at 10:06 am

    #890760

    Thanks Todd,

    node 3 is the preferred owner for INS2, INS3, and INS4 in Cluster administrator, and the failback option enabled.

    But onething I observed that the Clustergroup has NO prefered owners at all. Do I need to add all the nodes as ownwers?

    Thanks in advance

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

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