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.