Hi,
Where does the msdtc.log file need to be located on a Win2K setup with SQL7
?

Hi
On a cluster the MSDTC resources will be installed into a resource group,
and hence its log files will be created on a drive within that group. There
are 3 choices for where you can put the MSDTC resources.
1) In the same group as SQL Server
2) In the Cluster group (default on win2K)
3) In its own group.

Option 3 is the most robust as MSDTC is completly seperated from other
applications (SQL / Cluster).
When you run comclust on a windows 2000 cluster to create the MSDTC
resources they will be created in the cluster group.
You can put MSDTC in the same group as SQL, but this means that SQL and
MSDTC are potentially going to interfere with each other. So if MSDTC fails
it will failover and take SQL with it. (and visa-versa) which is not
generally recommended.
If you MSDTC resource is either in the cluster group of its own group and
is not causing any issues I would not move it, as this procedure in itself
can result in some downtime.

Regards,
Clive Challinor [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.