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.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.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment