How to Fail-over MSDTC and Quorum Resources in Windows server 2003/R2 cluster

On By ADsqlIn Uncategorized
Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.

Note:  Best viewed in Internet Explorer 6 and above

Implementation: How to Fail-over MSDTC and Quorum Resources in Windows server 2003 R2 cluster.

Scenario: Today I have been asked to fail-over the MSDTC and Quorum cluster resources to another active node where SQL server resource group was online and owned.

Consider two node NODE15 and NODE16 and active/passive cluster scenario.

  1. SQL Server resource was owned by Node15 (Assume)
  2. MSDCT and Quorum was owned by Node 16(Assume)

Since the MSDTC and Quorum was owned by NODE16 hence the its drives,network name and IP was also owned by NODE16.

So client wanted to move resources back to NODE15.

Infrastructure: This steps are for the Windows server 2003/R2 cluster only.

The Fail-over cluster is totally changed,manageable and handy from windows server 2008 onward.

For Windows server 2003/R2 it is bit confusing.

Here I am going to guide how to fail-over the MSDTC and Quorum resource to another node.

Step 1:

Go to Server NODE16–>All program–>fail-over cluster manager–>Expand the Windows fail-over cluster name–>expand the group–>Highlight the MSDTC group

Once you highlight the MSDTC group, on right pane you will see its resources list like Disk,IP and network name.

MSDTC Resource.png

Note: Here the MSDTC group resources are online ad owned at NODE16

Step 2:

Now right click on the MSDTC group and select the option move group as per image above.
The MSDTC group is separate group

Note: As soon as you click move group, Cluster manager start moving resources to NODE15 and you can see the change in status on right pane.

Step 3:

Move Quorum Disk:

Go to Server NODE16–>All program–>fail-over cluster manager–>Expand the Windows fail-over cluster name–>expand the group–>Highlight the cluster group

Once you highlight the cluster group, on right pane you will see its resources list like cluster name,IP and Quorum disk.Qourum disk.png

Note: As soon as you click move group, Cluster manager start moving resources to NODE15 and you can see the change in status on right pane.

This is how you can fail-over the MSDCT resources and Quorum disk in windows server 2003/R2.

Hope this will help out for those DBA who may receive same requirements from client.