Microsoft Distributed Transaction Coordinator (MSDTC) recovery techniques in Windows 2000 Cluster Server
Note Microsoft only supports running MSDTC on cluster nodes as a clustered resource. If SQL Server is clustered, only one clustered instance of MSDTC is required to support the maximum number of instances of SQL. The recommended procedure for installing an MSDTC Resource is to install it in its own resource group with its own disk and IP resources. If the MSDTC resource has already been installed, regardless of the location, and the applications that are using it are functioning correctly, we recommend that you leave it in that location. If the cluster is not yet in production, the following procedures can be used to move the MSDTC resource to a group other than the Cluster Group.
The MSDTC Cluster Resource will install in the first group that has a Physical Disk, IP Address and Network Name Resource configured and Online. Failure to make those resources available and online in a group other than the Cluster Group will cause the DTC Resource to be installed in the Cluster Group when you run the Comclust.exe command. By default, the Cluster Group contains the following resources:
- Cluster IP Address
- Cluster Name
- Quorum (Physical Disk with the /MSCS folder)
Note In an Exchange 2000 cluster or in an Exchange 2003 cluster, it is a best practice to leave the clustered MSDTC resource in the cluster group. Exchange accesses this functionality only during the initial installation process and when any Exchange specific service packs are applied. For more information about SQL Server-specific instructions for moving or recovering the MSDTC resource on clustered SQL Server installations, click the following article number to view the article in the Microsoft Knowledge Base:
Additionally, you may experience issues with the MSDTC log file that should be located on the first Physical Disk Resource in the group in which you installed the DTC Resource.
If you experience issues with the MSDTC service, or a DTC Resource in a Windows 2000 cluster, you can use one of the procedures described in this section to recover.
MSDTC Cluster Resource Is Mistakenly Installed in the Cluster GroupIf the DTC Resource was mistakenly installed in the Cluster Group, follow these steps to move it to the correct group. You should not use the Change Group functionality in Cluster Administrator to accomplish this task.
- Start Cluster Administrator. In the Cluster Group, locate the MSDTC Resource, take it offline, and then delete it.
Note Ensure that you delete all dependencies on this MSDTC Resource before performing this operation, or you may receive error messages prompting you to delete the dependencies before you can take the resource offline, or delete it.
- Use Registry Editor (Regedt32.exe) to ensure that the following registry keys have been deleted on both nodes:
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC (requires manual removal)
- Move the Cluster Group to the other cluster node. Verify that the Cluster Group is online on the other node before proceeding to the next step.
- Create the following resources in the desired group:
- The IP Address Resource that the MSDTC Resource will use. Bring the resource online.
- The Network Name Resource that the MSDTC Resource will use. Make this dependent on the MSDTC IP Address Resource that you created in the previous step. Bring this resource online.
- The Distributed Transaction Coordinator Resource that is dependent on the MSDTC Network Name, and the Physical Disk where the Dtclog folder will be located (see next step). Leave this resource in an offline state.
- Copy the Dtclog folder from the %WinDir%\System32 folder to the first physical disk resource in the group in which you want the MSDTC resource to be installed.
- Run the comclust command on node A, and then on node B.
Note If you receive the following error message reboot all nodes and try step 6 again:
C:\Documents and Settings\Administrator>comclust Setting up MS DTC. Setup found that the current configuration of the cluster does not contain any resource groups in which the MS DTC resource can be created. Setup of MS DTC requires that the cluster contain at least one resource group that contains both a network name resource and a shared disk resource. Setup also requires that this resource group be owned by the first node in the cluster on which setup is run. Please re-run setup after the appropriate changes to the cluster configuration have been made.
MSDTC Log IssuesIf you suspect an issue with the MSDTC log, you can flush any existing packets in the MSDTC log by running the msdtc.exe -resetlog command.
Warning The msdtc -resetlog command is a dangerous operation; verify that you do not have active transactions when you perform this operation.
Article ID: 243204 - Last Review: 12/05/2015 16:09:09 - Revision: 5.7
- kbnosurvey kbarchive kbproductlink kbhowto kbnetwork KB243204