SQL Server Performance Forum – Threads Archive

MSDTC on cluster

Dear all, We have to configure two node active/passive cluster on windows 2003 R2 with sql server 2000. now we some limitation with the shared disk. we have one Quram drive which is raid1 and another drive with raid5 and one more disk which is kept for backup. Now we need to configure MSDTC on the cluster which need to a disk, but we don’t have that. so we are thinking to configure this MSDTC on the backup disk can we do this?? will this create any issue or what else we can do?? Please guide me on this. Thanks
Sunil

---

If you dont have heavy MSDTC usage let it use the quorum disk instead. The MSDTC service will den be located in the default cluster group where you have the cluster ip and name.

---

Thanks for the reply:
so i can use quram drive for MSDTC right.. its better than using backup drive.. right?? actually we don’t have much use of MSDTC. Sunil

---

It has to be in a cluster group that has an IP and a name resource as well. I don’t think your backup drive has that unless it is located in your SQL Server group. And I wouldn’t put MSDTC in the same group as SQL Server. Put it on the group that has the quorum disk.

---

Thanks so i will use Cluster Group, which will also use Quram disk for MSDTC. one more question how should i install?? i will install SQL first and then MSDTC or MSDTC first and the sql server?? which is preferable please guide me on this as well. Thanks
sunil

---

Install MSDTC before installing sql…
Check the following article for step by step process… http://www.sql-server-performance.com/rn_sql_server_clustering_2000_to_2005_4.asp
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

]]>