database mirroring - between 2 production servers

we are having 2 prodction servers in our environment.

and we are planning to perform database mirroring between them.i want to mirror server 1 databases to server2 and server 2 databases to server 1.

is this possible?

if possible , can any one give me a link to document where i can find more info on this, or send me the steps what i need to done for this...

thanks

Haven't we discussed this on SSP forums ?

The process of setting up database mirroing is documented in Books online, have you looked there?

|||

hi sathya,

i am really confused with the concept in my scenario.that's why i am posting everywhere...

i can establish the mirroring between the 2 servers with the principal and the mirror script you posted to me. like creating the certificate,master key and dbmirrorendpoint for principal and the mirror server seperately...

now my scenario is different , i alredy mirrored the prodcution databases to server2, and failed over to server 2(which is now acting as principal m server).

now we want to mrror thoese databases to our new 64 bit server, in that server shall i need to run mirror script or principal script....

because server 2 already having mirror script..

please help me out in this situation...

|||

Priya, from your question this is what i understood..........you have mirroring configured from server 1 to server 2 and you have failed over to server 2 so it has become the principal now..........then from server 2 you want to configure mirroring to someother server sql server .......it is possible.......i dunno abt the scripts you are talking abt......

|||

Yes this is possible ; For more information on configuring Database Mirroring refer Books Online.

HTH

Vishal

sql