1

We currently have a 2 node (Win2003) SQL 2005 Cluster running 2 instances.

We need to move all drives to a new SAN but are pondering over how to move the DTC that is currently 'logging' te Quorum drive.

How can we see if the MSDTC is actually in use? The log file shows a date over 2 years old, but looking at the DTC service - its started.

Also whats the best way of moving it? Can we just hack the registry to change any reference to the current drive letter?

Cheers

Joel Mansford
  • 985
  • 1
  • 5
  • 13
NobbySQl
  • 11
  • 1

1 Answers1

0

At a previous job, I used to have to install new clusters all the time. So I came up with a command file to do the install. It should provide a way forward for you. Just make sure you change the relevant parts (server names, IP addresses, disks).

cluster ClusterName group "MSDTC Group" /create
cluster ClusterName group "MSDTC Group" /setowners:server1,server2

cluster ClusterName res "MSDTC IP Address" /create /group:"MSDTC Group" /type:"IP Address"
cluster ClusterName res "MSDTC IP Address" /priv network=public
cluster ClusterName res "MSDTC IP Address" /priv Address=127.0.0.1
cluster ClusterName res "MSDTC IP Address" /priv SubnetMask=255.255.255.0

cluster ClusterName res "MSDTC Network Name" /create /type:"Network Name" /group:"MSDTC Group"
cluster ClusterName res "MSDTC Network Name" /priv Name=MSDTCClusterName
cluster ClusterName res "MSDTC Network Name" /adddep:"MSDTC IP Address"

cluster ClusterName res "Disk M:\" /move:"MSDTC Group"

cluster ClusterName res "MSDTC Resource" /CREATE /GROUP:"MSDTC Group" /TYPE:"Distributed Transaction Coordinator"
cluster ClusterName res "MSDTC Resource" /ADDDEP:"MSDTC Network Name"
cluster ClusterName res "MSDTC Resource" /ADDDEP:"Disk M:\"
cluster ClusterName res "MSDTC Resource" /ON
Ben Thul
  • 2,969
  • 16
  • 23