Post reply

Need of MSDTC as cluster resource

  • August 27, 2011 at 12:29 am

    #390289

    Hi,

    We are building a 2 node Active/Passive cluster for sql server 2008 R2 and this instance going to store the Share Point 2010 databases. I'm going through the below link

    Question:

    Does Share Point application require/ uses MSDTC? and does MSDTC has to be configured as cluster resource when the cluster nodes are dedicated to store Share Point 2010 databases?

    Please advice

    Thanks

  • August 27, 2011 at 3:36 am

    #1374209

    may i ask why you dont want to cluster MSDTC??

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • August 28, 2011 at 7:07 am

    #1374286

    I know for sharepoint 2007 , you need to use "distributed transaction coordinator" service.

  • August 30, 2011 at 5:44 am

    #1374899

    If you're clustering SQL Server then you need to cluster MSDTC. If the clustered SQL Server instance fails over and the local MSDTC is in use then after failover the local DTC name would be invalid. This is why you cluster MSDTC with a clustered instance of SQL Server.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

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