Home Forums SQL Server 2014 Administration - SQL Server 2014 What kind of technology should i use? RE: What kind of technology should i use?

  • August 23, 2017 at 11:53 am

    #1956463

    Michael L John - Wednesday, August 23, 2017 8:09 AM

    If you decide to use an availability group, you may need Enterprise edition.  Standard edition only supports one database in an AG, so if you have more then one database that needs to be part of this, you will need enterprise. 

    And, if there are only 2 nodes, you will also need a witness as a "tie breaker".  The witness does not need to be a third server.  It can be a file share.  

    If you want to read, start here:
    http://www.sqlservercentral.com/stairway/112556/

    Well... 2016 standard edition could still work. The setup is more complicated but it can be done. Standard (2016 sp1 to be clear here. Pre sp1 does not support basic availability groups) also supports automatic failover. We have a client that we are working through the setup of multiple BAGS with listeners on Standard edition.

    Here is a method to do that advanced BAGs setup
    https://sqljudo.wordpress.com/2016/07/25/a-group-of-basic-availability-groups/

    The fileshare witness does need to be sitting on a server not acting as a node in the AG. I do recommend adding this additional "vote".

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events