July 7, 2010 at 1:27 am
Hi,
Would like to know the importance of MSDTC service in SQL Clusttering?
Under normal circumstances, i know that it is used for communication between the 2 SQL Servers.
Meaning, if we stop the MSDTC service, the Linked Servers will not work.
But incase of SQL clustter configuration, MSDTC is created as a separate Group, separate disk dive and IP address
Why is it so important to assign a separate disk and what significnce it has in Clusttering?
Thanks in Advance
July 7, 2010 at 4:07 pm
You only require DTC if you will be using distributed transactions.
MSDTC is separate because no matter how many instances of SQL you install on the cluster node the one MSDTC install will service them all.
---------------------------------------------------------------------
July 7, 2010 at 11:52 pm
Got it! makes sense.
Thanks George.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply