December 15, 2014 at 4:33 pm
Hello All,
We have two new DTC servers set up and two new drives for these services and services. I'm new to this so bare with me. Basically, we attempted to assign the two new servers the new disks and then take the old DTC service offline. However, when a failover with AG was done, we got a ton of errors and the DTC service didn't fail over properly. We want to make sure that when a failure occurs, the DTC and disk fails over to the secondary server. Does anyone here have some insight they could provide?
Edit:
I'll try to explain it better to show you our intent.
We have a cluster with two nodes. We want to create two different DTC Roles. One for Node 1 and one for Node 2. Both of which will be assigned separate disk. If Node 1 goes down, we want the AG group to switch over (this is manual), the server to switch to Node 2, and the DTC with Disk to switch over to Node 2 as well. I wasn't here at the time, but I believe that this is what caused a problem, this didn't happen. My guess is that it's something dealing with the configuration. If I assign the disk properly, and assign the sql server instance properly, if Node 1 goes down, DTC should fail over correct?
January 12, 2015 at 3:16 pm
I just wanted to fill you guys in on what I discovered during my research. Unfortunately, there's not a lot of data around on DTC issues with clustering and SQL Server.
When setting up DTC as a role in a cluster, you can not have one server take advantage of two DTC roles automatically. Let's say for example you have two nodes, one SQL server, two dtc roles and two logical disks for DTC. SQL Server will automatically assign itself the the default DTC role. If there is a failover, DTC will automatically switch over from node 1 to node 2 and DTC transactions will continue as expected. However, in the instance where DTC itself fails or the disk assigned to the DTC role fails, the SQL Server instance will not automatically switch to the second DTC role. The only this can happen is if you restart SQL Server or delete the original DTC role.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply