Tag Info

Hot answers tagged

8

Elijah. There's two separate questions here: 1. Is DTC supported with AlwaysOn Availability Groups? As Microsoft says in big letters, no. I totally understand that you want to try it anyway, but keep in mind that you're now putting something into production that Microsoft simply will not support, AND you're using two separate niche features together (AGs ...


5

I would imagine its either: EXEC sp_serveroption @server = 'ServerB',@optname = 'remote proc transaction promotion', @optvalue = 'false' ; Use this option to protect the actions of a server-to-server procedure through a Microsoft Distributed Transaction Coordinator (MS DTC) transaction. When this option is TRUE (or ON) calling a remote stored ...


3

MSDTC is not required for a SQL Server 2012 fail over cluster. However, if you plan to use Linked Servers, then you will need to create a clustered MSDTC resource. The good news is that can be setup after the cluster is already built and after SQL Server has been installed.


2

Microsoft Distributed Transaction Coordinator is a service that runs on the machine that cannot be configured per database. The service is either installed, or it isn't. Since a distributed transaction must use a linked server, you could theoretically use permissions on any linked servers you have configured to allow only your process access. You could ...


2

MSDTC has to be installed on a separate drive while rest can be installed on another drive. EDIT MSDTC is needed on separate drive because once you start installing SQL Server, the drive where MSDTC is installed won't be selectable and you will see message on screen something like "Cluster Disk 2 is already in use by MSDTC". Secondly, according to ...


1

There are two Distributed Transaction Standards Supported by the DTC. XA Transactions and OLE Transactions and recovery is implemented differently. XA Transaction Recovery Process use xa_recover_entry of GetXaSwitch to get a list of xid from the transaction resource manager (SQL Server is a resource manager) that it then uses to rollback or commit the ...


1

You can get the correlation you're looking for in the sys.dm_tran_active_transactions DMV. The column is transaction_uow. http://msdn.microsoft.com/en-us/library/ms174302.aspx


1

Have you configured MSDTC on both the source and target machine using dcomcnfg? The distributed transaction coordinator, by default, does not allow distributed transactions. You need to configure it by running dcomcnfg as an administrator, and configure the options applicable to your situation:


1

The job has several steps. In the step that ran the package, I had to select "SQL Server" as the package source instead of "SQL Server Package Store". This stopped the use of MSDTC.


1

The article isn't well worded but here's what I think it's saying Beginning scenario - DatabaseA is in an AG and is currently primary on Server1 and can run on Server2. DatabaseB can only run on Server1 T1 - Transaction begins T2 - Row inserted into DatabaseA (log not yet sent to Server2 though) T3 - Row inserted into DatabaseB T4 - Transaction commit ...



Only top voted, non community-wiki answers of a minimum length are eligible