MSDTC
-
MSDTC Best Practices with an Availability Group
In this article we are going to look at some guidelines and MSDTC best practices with an Availability Group. Please note that some of these recommendations change if you are deploying a Failover Cluster Instance. If you are using the MSDTC (BizTalk, Linked Servers, etc.) and hosting the databases in an Availability Group, there are…
-
Configure SQL Server Failover Cluster Instance on Azure Virtual Machines with MSDTC
Configure SQL Server Failover Cluster Instance If you are running a SQL Server Failover Cluster Instance on premises and looking to migrate to Azure, you might be a little intimidated. This architecture is a bit complex because it uses quite a few different technologies all working together. My goal is to help clarify the pieces…
-
MSDTC Supported Configurations
The MSDTC Configuration Conundrum MSDTC configuration is not as straight forward as you might think. It’s a different choice if you are using a local MSDTC, clustered MSDTC, on-premises, Azure, Failover Cluster, or Availability Group. Every one of those variables leads you down a different path with different choices. The goal of this article is…
-
High Availability and Disaster Recovery Training in Austin
I’ll be doing a precon for SQLSaturday #461 in Austin on January 29th, 2016 titled “Creating a High Availability and Disaster Recovery Plan” . If you are in the area or thinking of attending this event, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster Instances,…
-
High Availability and Disaster Recovery Training in Dallas
I’ll be doing a precon for SQLSaturday #447 in my home town of Dallas on October 2nd, 2015 titled “Creating a High Availability and Disaster Recovery Plan” . If you are in the area or thinking of attending this event, I would love to have you in the class. We are going to cover backups, windows clustering,…
-
SQL HA and DR Training in Oklahoma City
I’ll be doing a precon for SQLSaturday #422 in Oklahoma City on August 28th, 2015 titled “Creating a High Availability and Disaster Recovery Plan” . If you are in the area or thinking of attending this event, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster…
-
How to move Cluster MSDTC Drive
I recently had the need to move the MSDTC for a cluster to a new SAN drive. It’s a quite simple thing to do, but you can’t redirect the MSDTC resource to a new drive. Let’s just walk through the basic steps. The first thing you need to do is get the new drive added to the cluster and…