Puvendran


Hi,

I have the following scenario

1. 2 databases A & B which are both mirrored in high safety mode (manual failover)

2. The mirror of A & B are on a separate and remote site in relation to the Principal

3. Some of the application functions insert/update to database A&B as one transaction unit

My query is give the above scenario should I expect any DB incosistency on the mirror Partners for A & B in relation to cross db transactions I believe not as the update on the Primary should be commited as whole on both Principal databases & mirror databases prior to the client getting confirmation on commit.

Further my understanding is that even in an automated failover with synchronous mirroring there should be no issues with cross DB transactions.

Are my assertions correct

Thanking you in advance for any feedback.





Re: Mirroring and Cross DB transactions

Peter Byrne MSFT


No, this is not right.

There is a topic in Books Online that covers this

SQL Server 2005 Books Online
Database Mirroring and Cross-Database Transactions