Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Manual failover of cluster-MSDTC Expand / Collapse
Author
Message
Posted Friday, March 29, 2013 8:30 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:26 AM
Points: 381, Visits: 1,857
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?
Post #1436962
Posted Friday, March 29, 2013 9:19 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:26 AM
Points: 381, Visits: 1,857
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?
Post #1436974
Posted Tuesday, April 9, 2013 5:44 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 5:44 AM
Points: 66, Visits: 437
DTC is only required when the linked servers is using distrbuted transactions. Other functionality like replication might also need DTC.
Post #1440278
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse