MSDTC and SQL instance are not in the same node.


hi,

i have 2 cluster nodes db01 , db02. there no problem or error occured i'm afraid face problem in future.

i saw sql server instance , quorum in db01 msdtc in db02. normal?

do have to move msdtc db01? interupt sql if move it?

regards

hi

 the msdtc  (transaction manager) coordinates client,sql ,  resource managers ensure succeed requested work or none of work if done, maintaining acid properties. doesn't matter resource resides in server , if performing maintenanace activity in db02 can move cluster msdtc resource db02 db01 without interrupting sql.

thanks

hemanth



Windows Server  >  High Availability (Clustering)



Comments

Popular posts from this blog

Azure MFA with Azure AD and RDS

Failed to setup initiator portal. Error status is given in the dump data.

Invalid pointer on gpresult /h gpreport.html