SQL 2008 Mirroring + Mirroring + Log Shipping

  • Using SQL 2008 R2,

    1. Can I create either a Mirror off of a Mirrored database, or can I create 2 Mirrors off of one principal?

    2. Having 2 instances with mirrored databases, can I also create a log shipped database off of the principal, which ever server is the pricipal?

    Thanks!

  • alanspeckman (9/3/2013)


    1. Can I create either a Mirror off of a Mirrored database, or can I create 2 Mirrors off of one principal?

    No and no.

    2. Having 2 instances with mirrored databases, can I also create a log shipped database off of the principal, which ever server is the pricipal?

    Yes. It's a little harder than log shipping a standalone, but there are documents explaining the process around.

    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

Viewing 2 posts - 1 through 1 (of 1 total)

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