Post reply

Database Mirroring (Mirror a database to two locations)

  • November 23, 2011 at 8:41 am

    #247386

    Does anyone know if one database can be mirrored to two different locations with the generic database mirroring set up?

    Please advise.

  • November 23, 2011 at 8:47 am

    #1412265

    Not until Denali gets released. Currently you can only have a single mirror. If you want two locations then you have to mirror to one and log ship to the other.

    Once Denali is released (as SQL 2012), then you will be able to mirror to up to 4 locations, but I believe they're now calling then replicas rather than mirrors.

  • November 23, 2011 at 8:53 am

    #1412272

    Do you know if a back-door exists for said issue?

  • November 23, 2011 at 10:02 am

    #1412337

    In 2008 a mirroring setup can only have one principal and one mirror. End of story.

    SQL 2012 (Denali) has AlwaysOn which allows for multiple active replicas. This is a new feature, it's not an enhancement to mirroring, SQL 2012 will still have the old mirroring feature as well

    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

  • November 23, 2011 at 10:12 am

    #1412345

    spenn6367 (11/23/2011)

    Do you know if a back-door exists for said issue?

    log shipping

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

  • November 23, 2011 at 10:32 am

    #1412357

    Thanks, All

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

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