Do MSDTC and disaster recovery go together?
Posted
by DevDelivery
on Server Fault
See other posts from Server Fault
or by DevDelivery
Published on 2010-03-18T01:35:14Z
Indexed on
2010/03/18
3:41 UTC
Read the original article
Hit count: 609
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)?
© Server Fault or respective owner