MSDTC and sql server on cluster

  • I don’t quite understand what is the purpose of msdtc on cluster server. I think that sql server need msdtc to function well that is to perform failover but I am not sure of that. Lave me some links if you have or some explanation

  • From-->http://blogs.msdn.com/sqlblog/archive/2006/10/06/MSDTC-and-SQL-Server-on-a-cluster.aspx

    Do I need to install MSDTC on my SQL Server 2005 cluster?

    Before installing SQL Server 2005 on a failover cluster, Microsoft strongly recommends that you install and configure Microsoft Distributed Transaction Coordinator (MS DTC) on Windows 2000 and Windows Server 2003 operating systems.

    Failure to cluster MS DTC will not block SQL Server 2005 Setup, but SQL Server 2005 application functionality may be affected if MS DTC is not properly configured.

    What is MSDTC used for?

    SQL Server 2005 requires MS DTC in the cluster for distributed queries and two-phase commit transactions, as well as for some replication functionality.

    Should MSDTC be a clustered resource?

    Microsoft only supports running MSDTC on cluster nodes as a clustered resource. We do not recommend or support running MSDTC in stand-alone mode on a cluster. Using MSDTC as a non-clustered resource on a Windows cluster is problematic. This configuration is problematic because transactions could be orphaned and you may experience data corruption if a cluster failover occurs.

    MJ

  • thus this means that if I have transactions just on my server that I do not need msdtc?

  • irena.bulatovic (3/2/2009)


    thus this means that if I have transactions just on my server that I do not need msdtc?

    That is correct. As long as you are not distributing transactions across servers, you should not need MSDTC turned on.

  • Even if my server is cluster? This means that it does not need msdtc for failover?

  • Hi,

    I have a doubt. Even Linked Server is using DTC right? Is it different from MS-DTC? Even we have only configured MSDTC for Transactional Replication with Updatable Subscription Servers. But when we expand support services in EM there is a option called DTC...

    Regards,
    Sakthi
    My Blog -> http://www.sqlserverdba.co.cc

  • irena.bulatovic (3/4/2009)


    Even if my server is cluster? This means that it does not need msdtc for failover?

    It should not matter if you are on a cluster or not. The only difference that being on a cluster makes is how you manage MSDTC, but not how it is used (the setting will follow SQL when you failover).

    As mentioned by the other poster, if you are using Linked Servers with explicit transaction, you will have to have MSDTC turned on. However if every statement/transaction you run on this server (clustered or not) is run again db's within that server you will not have to have MSDTC turned on.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply