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
Post a Comment