Adding 3 rd node in Alwayson

• gana79950

  Old Hand

  Points: 371

  More actions

  October 1, 2019 at 9:17 pm

  #3685138

  Hi,

  We have 2 node Alwayson setup. Planning to add 3rd node. To add 3rd node, do we need to remove databases from AG and re-configure them from scratch after adding 3rd node?

• andreas.kreuzberg

  SSCertifiable

  Points: 6191

  More actions

  October 2, 2019 at 6:41 am

  #3685207

  Hi,

  no, you need not to create the ag new from scrath, you only have to add the 3rd node to the aoag. You can do this via gui or script:

  https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/add-a-secondary-replica-to-an-availability-group-sql-server?view=sql-server-2017

  Kind regards and good luck,

  Andreas

  • This reply was modified 5 years, 2 months ago by  andreas.kreuzberg.