Always On manual script

Question

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 ?

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

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

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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.