• Question

  • Hi,

     is MSDTC service  need for log shipping,replication,database mirroring and clustering  when move the transaction one server to other server

    • Moved by Kalman Toth Thursday, March 28, 2013 8:01 AM Not db design
    Thursday, March 28, 2013 4:53 AM


All replies

  • Hello,

    MSDtc is not required for log shipping / replication / mirroring and/or clustering.

    DTC = Distributed Transaction Coordinator is only required when you want to run Transaction on a remote / not only on the local Server.

    Olaf Helper

    Blog Xing

    Thursday, March 28, 2013 5:12 AM
  • if you implement transaction handing in SSIS,then you will need DTC use.

    DTC service should be running otherwise transaction handling will not work..

    Regards http:\\sqldbatask.blogspot.com MCTS Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    Thursday, March 28, 2013 10:39 AM
  • For some replication types, MSDTC is required.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

    • Proposed as answer by Fanny Liu Thursday, April 4, 2013 5:58 AM
    • Marked as answer by Fanny Liu Thursday, April 4, 2013 6:05 AM
    Thursday, March 28, 2013 3:54 PM
  • Hi,

    Log shipping and Mirroring MSDTC is not required.

    Yes MSDTC is required for Transactional replication with updatable subscriptions.

    It is highly recommended that MSDTC is part of cluster group.

    Rajesh Kasturi Please click the Mark as Answer button if my post solves your problem.

    • Marked as answer by Fanny Liu Thursday, April 4, 2013 6:05 AM
    Friday, March 29, 2013 12:51 PM
  • Most of the time MSDTC is used by Mirroring and Clustering.

    Regards JakDBA Please Mark this as Answered if this solves your issue or satisfied with the response.

    Monday, April 1, 2013 2:28 PM