March 29, 2013 at 8:30 am
I tried to manually failover the sql service to another node. I was successfull in doing so, but MSDTC remains on the passive node. Let us assume in network guys are applying patches on the passive node. They just moved the sql services to the other node and msdtc remains on the passive node. Does it creates any problems?
March 29, 2013 at 9:19 am
Also can somebody explain me this sentence--
•If you have linked servers running distributed transactions, then MS DTC is required.
We have linked servers established from cluster server to other non clustered servers. So we need to have MSDTC?
April 9, 2013 at 5:44 am
DTC is only required when the linked servers is using distrbuted transactions. Other functionality like replication might also need DTC.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply