Post reply

Basic availability group

  • July 10, 2018 at 9:06 pm

    #366119

    Hi,
    Sql: sqlserver2016 standard edition
    Trying to setup basic availability groups .
    Are the four different ips required for four basic availability groups ?
    We have one application using these four databases.
    Need to provide one listener name/ ip for the application connection.

    Thanks.

  • July 10, 2018 at 10:34 pm

    #1997093

    Yes, with Basic Availability Groups you can only have 1 x database and IP assigned per BAG. 
    If you applications needs 1 x connection string/listener name, BAGs won't work for you.

    There is an alternative using address forwarding, but I will not recommend it.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • July 11, 2018 at 4:56 am

    #1997107

    Henrico Bekker - Tuesday, July 10, 2018 10:34 PM

    Yes, with Basic Availability Groups you can only have 1 x database and IP assigned per BAG. 
    If you applications needs 1 x connection string/listener name, BAGs won't work for you.

    There is an alternative using address forwarding, but I will not recommend it.

    Thank you.

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

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