deep_kkumar (4/12/2013)
Thanks Perry. Too many questions.
You're welcome, i don't mind, really.
deep_kkumar (4/12/2013)
I have setup a two node cluster and now adding a third node to it. I have asked for 3 drives for system db files, used db data files and user db log files for second instance. So we need to share the other drive volumes existing on other two nodes and these three new volumes to be shared between on all three nodes. Right? So that we can failover to any node we want to if needed. Correct me if I am wrong.
It all depends on how you want your cluster to operate and respond to failures.
Say you have a 3 node cluster NodeA,NodeB,NodeC.
Instance 1 is installed on NodeA and NodeC
Instance 2 is installed on NodeB and NodeC
You would typically mask or zone the storage for instance1 from NodeB and likewise instance2 from NodeA.
This design may not suit you at all, there are many ways of achieving a highly available SQL Server system, how do you want it to respond?
deep_kkumar (4/12/2013)
And also we have to select the same MSDTC and Quorum drive used in other two node cluster while installing the failover cluster on the third node.
If you're using a disk witness this storage device obviously has to be available on every node in the cluster. The following services are in my opinion the common resources you would fail on any node in a multi node cluster
Msdtc
File
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉