Database Mirroring - Multiple databases

I know database mirroirng is on the database level but is it possible to fai
l
all the databses in the server if one databses fails.
If I want to mirror db1 and DB2 serverA to db1 and DB2 in serverb. If db1 in
servera fails I want DB2 in servera fails therefore both database will
rollover to serverb.No, first off database mirroring is not scalable to a large number of
databases. Secondly what will happen is each mirroring pair will failover on
its own schedule. All of them should fail over within several seconds
though.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"bashir" <bashir@.discussions.microsoft.com> wrote in message
news:1379FB0F-C815-4DEB-B0B0-CD25F03693ED@.microsoft.com...
>I know database mirroirng is on the database level but is it possible to
>fail
> all the databses in the server if one databses fails.
> If I want to mirror db1 and DB2 serverA to db1 and DB2 in serverb. If db1
> in
> servera fails I want DB2 in servera fails therefore both database will
> rollover to serverb.
>sql