Do MSDTC and disaster recovery go together?
Posted
by DevDelivery
on Stack Overflow
See other posts from Stack Overflow
or by DevDelivery
Published on 2010-03-18T01:35:14Z
Indexed on
2010/03/18
1:41 UTC
Read the original article
Hit count: 582
Our application writes to multiple Sql Server databases within a distributed transaction. The Ops guys are saying that this messes up their disaster recovery plan because while the transactions on the live tables may commit at the same time, the log shipping on the separate databases happen at slightly different times. So in in a disaster recovery situation, there will be a few partial transactions.
Is there a method for maintaining separate but synced databases in DR? Or do we have to re-design to relatively independent databases (or a single database)?
© Stack Overflow or respective owner