Post reply

2 copies of mirroring database

  • June 25, 2014 at 8:38 am

    #290338

    Hi guys,

    is it possible ABC database on server 1 mirror on server 2 and server 3? another word can I configure mirroring of the same database to 2 different servers ( 2 copies)?

  • June 25, 2014 at 11:07 am

    #1724730

    Nope. Mirroring is a single Principal and a single Mirror. Other options would be replication, log shipping, SAN tools (replication, etc).


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • June 26, 2014 at 7:35 am

    #1725072

    Thanks for your input.

  • June 26, 2014 at 9:12 am

    #1725148

    Or if you are using SQL Server 2012/2014 Enterprises Edition, you can have multiple readable replicas with Always on.

Viewing 4 posts - 1 through 3 (of 3 total)

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