June 18, 2012 at 12:00 pm
Why do we need MSDTC service in place for clustering a SQL Server?
I read that MSDTC is used for running Distributed transactions. But in a cluster do we run distributed transactions?? We run on one node at a time right?
And the followup is if we need to run distributed queries using linked servers in an non-clustred environment do we need still need msdtc service in all the linked servers??
Thank you in advance.
June 18, 2012 at 1:42 pm
Please please please read this:
http://technet.microsoft.com/en-us/library/dd337629(v=ws.10).aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 18, 2012 at 1:53 pm
MSDTC has changed with SQL 2008 Win 2008 clustering, Now having MSDTC is no longer a requirement, you can have 0 MSDTC, or 1 , or more than 1 if you want.
http://msdn.microsoft.com/en-us/library/ms189910.aspx
Generally I do create 1 MSDTC, but you can create one after the install too, so you have that option too.
If you use distributed transactions you need MSDTC. Its also used in transactional replication with updateable subscriptions and immediate updates. Linked Servers & Remote stored procs use MSDTC. More on distributed transactions here:
http://msdn.microsoft.com/en-us/library/ms191440(v=sql.105)
So, you will need to do your own homework to figure out which features of SQL Server you are using and if they do or do not use MSDTC.
Stand-Alone: Don't worry about MSDTC install etc there. If you look under services.msc you would see DTC there.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply