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

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: 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)?

© Server Fault or respective owner

Related posts about disaster-recovery

Related posts about sql-server