Database Mirroring Restrictions

  • Hugo Kornelis (7/16/2015)


    Koen Verbeeck (7/15/2015)


    Meh, who cares about mirroring

    Perhaps, everyone who does not have the budget for Enterprise Edition?

    From BOL:

    If you are running an edition of SQL Server that does not support AlwaysOn Availability Groups, we recommend log shipping. For information about which editions of SQL Server support AlwaysOn Availability Groups, see the "High Availability (AlwaysOn)" section of Features Supported by the Editions of SQL Server 2014.

  • Carlo Romagnano (7/17/2015)


    Hugo Kornelis (7/16/2015)


    Koen Verbeeck (7/15/2015)


    Meh, who cares about mirroring

    Perhaps, everyone who does not have the budget for Enterprise Edition?

    From BOL:

    If you are running an edition of SQL Server that does not support AlwaysOn Availability Groups, we recommend log shipping. For information about which editions of SQL Server support AlwaysOn Availability Groups, see the "High Availability (AlwaysOn)" section of Features Supported by the Editions of SQL Server 2014.

    Yes, it figures that this is the BOL recommendation. Database mirroring is deprecated, so it will not be recommended in the official documentation.

    But database mirroring has several advantages that log shipping does not have. It is really a different solution, whereas DB mirroring is very much like a "light" version of AlwaysOn Availability Groups.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Easy question as I have attended to a session about the mirroring 2 years ago and the lecturer began ( in a clever way ) by giving the list of situations where mirroring is impossible and he recalled that mirroring was a dying feature.

    But this kind of question is useful as it is easy to find the good answer only if we take 2 minutes to eliminate the "bad" answers.

Viewing 3 posts - 16 through 17 (of 17 total)

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