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


  • 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




    Wednesday, June 13, 2007 4:27 PM

All replies