locked
Mirroring Mirror Database RRS feed

  • Question

  •  

    I have two questions here.

     

    Question 1:

    If I am using Database Mirroring for my production database in SQL Serever 2005, can I do mirroring on the mirror database?

     

    Principal Database -- Mirror -- Mirror A -- Mirror -- Mirror B

     

    Can this be done?

     

     

    Question 2:

    Can I do 2 mirroring on a single principal database? If can, which mirror database it will goes when the failed over happen? can the other mirror switch to mirror the failed over database?

     

    Principal Database -- Mirror -- Mirror A

                                           -- Mirror -- Mirror B

     

    Please advise. Thanks

    Wednesday, June 13, 2007 11:09 AM

Answers

  • neither of these two scenarios is currently supported. however, for scenario 2, you can achieve similar results if you use log shipping. e.g., you can have the following setup:

     

    principal   -- mirror ---> mirror A

                         -- log shipping ---> site B

     

    Take a look at the following MSDN article for more information:  http://msdn2.microsoft.com/en-us/library/ms187016(SQL.90).aspx

     

    cheers,

    kal.

    Wednesday, June 13, 2007 4:27 PM

All replies