Database Mirroring - Multiple databases

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.
>

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

database mirroring

I am new user of SQl and preparing the exam database mirroring....can you tell me how i start the mirroirng ..what is my first tep..and is there only one instance

The first step is, you need at least 2 instances for mirroring, otherwise it's meaningless.

I suggest you open up SQL Server 2005 Books Online and read every topic on mirroring thoroughly.

Why are you taking an exam in it if you don't know anything about it? Seems a bit pointless to me, maybe I'm just jaded and cynical.

|||hi thanks for replying...i know about sql server..but i m a new user,but i know every thing about mirrioring....but i want to take some step that i directly use mirrioing,..and i want to clear MCTS sql and but i read rea 12 time the database mirrioirng topic on msdn, one day i will be a shinner administrator..I will prove you after few months, but i need some help that why i reply you..please do me in a favour

database mirroring

I am new user of SQl and preparing the exam database mirroring....can you tell me how i start the mirroirng ..what is my first tep..and is there only one instance

The first step is, you need at least 2 instances for mirroring, otherwise it's meaningless.

I suggest you open up SQL Server 2005 Books Online and read every topic on mirroring thoroughly.

Why are you taking an exam in it if you don't know anything about it? Seems a bit pointless to me, maybe I'm just jaded and cynical.

|||hi thanks for replying...i know about sql server..but i m a new user,but i know every thing about mirrioring....but i want to take some step that i directly use mirrioing,..and i want to clear MCTS sql and but i read rea 12 time the database mirrioirng topic on msdn, one day i will be a shinner administrator..I will prove you after few months, but i need some help that why i reply you..please do me in a favoursql