Always On manual script

• leeor1

  SSC Rookie

  Points: 39

  More actions

  October 29, 2017 at 7:08 am

  #402624

  Hi, 

  I have 3 nodes always on.

  1. master
  2. secondary (auto)
  3. Secondary (manual).

  How do i change the master to the 3rd slave manually using tsql ?

• Henrico Bekker

  One Orange Chip

  Points: 27652

  More actions

  October 30, 2017 at 7:13 am

  #1965757

  If I understand your question correct, you should use ALTER AVAILABILITY GROUP:

  https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/change-the-availability-mode-of-an-availability-replica-sql-server

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

• leeor1

  SSC Rookie

  Points: 39

  More actions

  October 30, 2017 at 9:53 am

  #1965804

  Henrico Bekker - Monday, October 30, 2017 7:13 AM

  If I understand your question correct, you should use ALTER AVAILABILITY GROUP:

  https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/change-the-availability-mode-of-an-availability-replica-sql-I 

  Thank you fro your answer.

  But i need the script to change the master to slave with the 3rd node, and not the default node.

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  October 31, 2017 at 7:44 am

  #1965962

  Slave isn't a term that's used in Availability Groups.

  Take a look at Perry Whittle's Staircase here for lots of useful information.