locked
SQL 2012 versus SQL 2014 RRS feed

  • Question

  • Please confirm my understanding of the features below for SQL.

    In terms of a DR options:

    SQL 2012 standard - both synchronized mirroring DR and asynchronized mirroring DR

    SQL 2012 enterprise - both synchronized mirroring DR and asynchronized mirroring DR

    SQL 2014 standard - Only synchronized mirroring - DR;   No asynchronized mirroring DR

    SQL 2014 enterprise - both synchronized mirroring DR and asynchronized mirroring DR  

    AvailabilityOn - this applies to local datacenter HA solution.  Not a DR solution. Available in SQL 2014.  Not available in SQL 2012.


    dsk


    • Edited by kimdav111 Monday, April 16, 2018 7:21 PM
    Monday, April 16, 2018 7:20 PM

All replies

  • Standard edition for SQL 2012 and SQL 2014 only supports synchronous mirroring. Enterprise Edition support both synchronous and asynchronous. 

    Always on was introduced in SQL 2012. It can be used to mirror to a local or remote data center. It supports both synchronous and asynchronous mirroring and allows the mirror to be readable.

    SQL 2016 introduces the BAG (Basic Availability Group) which is available in the standard and enterprise edition. It has limitations.  
    https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups?view=sql-server-2017

    SQL 2016 also supports the full availability groups without the limitations of the basic availability group and also introduces distributed availability groups.

    Monday, April 16, 2018 8:28 PM
  • Is the below combination of AvailabilityOn/mirroring possible/version required:

    Server 1 and Server 2 are both located in datacenter A.

    Server 1 and Server 2 both have AvailabilityOn using synchronous replication.  

    Server 3 is not configured for AvailabilityOn.

    Server 3 is located in datacenter B using asynchronous mirroring with datacenter A (Server 1/Server 2). If this scenario is valid then we can also use synchronous mirroring between the datacenters (ie if we are want to use Standard Version).

    Does synchronous mirroring have any limitations?,... we have used mirroring from a East Coast datacenter to a Midwest datacenter,... would a greater distance like an East Coast datacenter to a Westcoast datacenter be difficult?,... we are using Azure express route between the datacenters?  What is the recommended bandwidth for synchronous mirroring?

    Or are you saying that a AlwaysOn group must include all three servers? If the replication between server 1 and server 2 is synchronous then the mirroring between server 3 and server1/server2 must be synchronous?  In other word the replication on AlwaysOn group must be either all asynchronous or all synchronous.  Would this scenario (3 servers in a AlwaysOn group) require Enterprise license or a Standard license?

    XXXXXXXXXXXXXXXXXXXX

    XXXXXXXXXXXXXXXXXXXX

    If BAG (Basic Availability Group ) has limitations over Full Availability Group then why is it offered in SQL 2016.   What is the difference of AlwaysOn for SQL 2012 versus SQL 2014 versus SQL 2016?

    Is Full Availability Group the same as the AlwaysOn group in SQL 2012 and SQL2014.

    Full Availability Group = Advanced Availability Group?

    Do we need a quorum (witness) when using AlwayOn groups?

    Do we need to configure a windows cluster?



    dsk










    • Edited by kimdav111 Monday, April 16, 2018 11:41 PM
    Monday, April 16, 2018 9:37 PM