I am configuring a two node SQL cluster and i have 5 physical disk arrays and
i intend to use them in the following order
disk array 1 for quorum
disk array 2 for DATA
disk array 3 for backup
disk array 4 for TempDB
disk array 5 create two partition (1 for Tlog and 2 for MDTC disk resorces)

Will there be any probelm or is there anything wrong with creating two
partitions on the disk array 5 to make available two disk resource for those
two resources i have mentioned above e.g the MSDTC resource and the TLOg
storage . Since i want the MSDTC resource to be in its own resource group.
Please any help will be gladly appreciated.

Clustering does not understand partitions, only disks. With that said, array
5 should stay one partition. MSDTC is only 4 MB by default. Are you sure you
will even use MSDTC with SQL? If not, you don't have to install it :)

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog

[quoted text, click to view]

While SQL Server does not require MS DTC, MS DTC on a cluster is only
supported when clustered and it is recommended to cluster it.

When clustering MS DTC it is preferred to have it in its own group with its
own resources, This will require your partion to appear as a physical disk
to place the disk in its own group.

Your second choice should be to put it in the cluster group,
use the quorum disk and create MS DTC its own Network Name and IP Address
resources for your MSDTC resource to use and set that resources properties
not to affect the group.

Here are some KB articles on correctly setting this up:

301600 How to configure Microsoft Distributed Transaction Coordinator on a
http://support.microsoft.com/?id=301600

817064 How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/?id=817064

Also this article which may be of interest:

817065 How To Enable Network COM Access in Windows Server 2003
http://support.microsoft.com/?id=817065

Dave Whitney
SQL Support