Post reply

Can we have multiple Secondary servers in Mirroring?

  • December 14, 2011 at 12:53 pm

    #251975

    Hi !

    Can we Configure Multiple secondary servers in Database Mirroring ?

  • December 14, 2011 at 1:09 pm

    #1421567

    I don't believe that is supported, only one destination for Mirroring.. It IS possible for Log Shipping though..

    CEWII

  • December 14, 2011 at 1:16 pm

    #1421574

    Iam thinking that the DB mirroring is at the database level is 1:1 and for log-shipping is 1:N.

  • December 14, 2011 at 1:52 pm

    #1421600

    nope.

    ---------------------------------------------------------------------

  • December 14, 2011 at 2:03 pm

    #1421607

    Thats 3 nays and no yays, the motion fails..

    Not allowed.. Sorry.

    CEWII

  • December 14, 2011 at 2:21 pm

    #1421620

    Not with SQL 2005 or SQL 2008 database mirroring. Single principal, single mirror, optional witness. The new Always On Availability Groups in SQL 2012 will allow multiple secondaries (new feature, the old mirroring still exists in SQL 2012)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 15, 2011 at 3:58 am

    #1421814

    in mirroring more than one mirror is not possible, if required u can have one witness server.

    Whereas, u can create more than one stand by server in log-shipping.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply