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. T
here'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...een">
> Is there any way we can handle cross database transaction on mirrored data
base'
> THanks
> DNB
>