Is our Cluster Configuration perfect???????????

  • Hello,

    We had build a new active/passive cluster with Node 1 and Node 2 on windows 2003 EE x64. We are going to install sql server 2005 EE x64.

    Befor doing that, I have couple questions to make sure cluster configuration has no issues

    1. What are the things I need to check to confirm the cluster configuration is fine?

    2.We have drives C,D,E,F,Q (Quorum) and Y (MSDTC) on node1 and node 2 has just C now.

    3.I created a group and added the D,E,F in that group.

    4.I moved the group to node 2 from cluster administrator and D,E,F are moved to Node2

    5.I moved the group back to Node1.

    BUT here, after moving back to node1, Iam still seeing the drives D,E,F on node2 and also on node 1.

    Is this normal behaviour or something wrong with the cluster configuration?

    Iam thinking that when we moved back to node 1, the drives D,E,F should not be visible from node2. Correct me if Iam wrong

    Many thanks

  • The drives will be visible but not accessible from node 2.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • thanks,

    1.You meant say that, if we move all the drives from node 1 to node 2, all the drives should be visible and accessible from node 2

    2.if we move all the drives from node 1 to node 2, and moved back to node 1, then all the drives should be visible and NOT accessible from node 2 right?

  • That is correct, once you have fully tested the cluster failover - all drives will be visible from both nodes and only accessible from the node where the resource exists.

    This is just a visual effect because all drives/lun's are visible to the O/S from all nodes. They can only be accessed from the node that owns the cluster resource, but the O/S still sees the drives/lun's.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • can we insatll Failover cluster instance database engine othe than C drive? Because Iam getting error while choosing other than C?

  • please clarify the above... and Books Online and workstation components were installing even if did not select them while the installation. Is that so??

Viewing 6 posts - 1 through 5 (of 5 total)

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