Is there any way we can handle cross database transaction on mirrored database?

Is there any way we can handle cross database transaction on mirrored
database'
THanks
DNBNot really. Database fail over individually. So if you have a cross database transaction in-flight
and now one of the database fails over, then the in-flight transaction will fail. Whether subsequent
transactions fails depends on whether the app has logic to do auto-redirect for the failed database.
Since only one of the database failed over, you will end up in a distributed transaction in this
case, unless you also ´"force-fail" the other databases when one db fails. There's no support for
failing several databases automatically (if one fails) so you would have to roll your own for that.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"DNB" <ii@.ii.com> wrote in message news:e2tvV4FLIHA.1168@.TK2MSFTNGP02.phx.gbl...
> Is there any way we can handle cross database transaction on mirrored database'
> THanks
> DNB
>