Hi Guys,

I am in the process of setting up failover cluster using SQL Server 2008  (64Bit) Enterprise on Windows Server 2008 R2 (64Bit) I have completed almost all the works but I got few questions regarding MSDTC configuration whether the MSDTC disk should be assigned from SAN or it should be local to the disk ,  Separate disk for each nodes in the cluter or 1 disk to be used across all the servers for MSDTC in windows fail over cluster.

IMHO, you need only one drive MSDTC  for entire cluster.   the disk would  SAN drive as it needs to roll over incase of failover.

once all done, use dtcping to test connectivity from app server to sql server.

I got few questions regarding MSDTC configuration whether the MSDTC disk should be assigned from SAN or it should be local to the disk ,  Separate disk for each nodes in the cluter or 1 disk to be used across all the servers for MSDTC in windows fail over cluster.

MSDTC disk should be from SAN and should be shared and visible to both nodes. Like you have configured other drives.