Basic availability group

• adisql

  SSCrazy

  Points: 2893

  More actions

  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.

• Henrico Bekker

  One Orange Chip

  Points: 27652

  More actions

  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

• adisql

  SSCrazy

  Points: 2893

  More actions

  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.