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

WIMMount (HSM) causing cluster storage to go redirected (2012r2 DC)

Failed to delete the test record dcdiag-test-record in zone test.com

Azure MFA with Azure AD and RDS