Home Forums SQL Server 2016 SQL Server 2016 - Administration sql server cluster and ag node RE: sql server cluster and ag node

  • May 3, 2018 at 4:14 am

    #1989046

    tcronin 95651 - Tuesday, May 1, 2018 7:43 AM

    Looking at building solution for our 2016 claims dept.  Was considering one of two options below (all of this on VMware and sql 2016 enterprise edition)

    1. Build active passive cluster and one AG with read only node
    2.Build AG with 2 sql instances failover other node as read only

    Any opinions

    Theyre not separate options, theyre the same.
    If you build a 2 node cluster you will need 2 sql server instances to support an AG.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉