question

SaiVijaya avatar image
SaiVijaya asked

How to bring Listener and AG offline and online

I am going to implement the below changes using powershell commands in Sql server 2017.
1. Change the RegisterAllProvidersIP parameter.
RegisterAllProvidersIP parameter value is 0
2. Reduce the HostRecordTTL.
HostRecordTTL paramenter value is 300
3. Take the listener offline.
4. Bring the listener back online.
5. Ensure the entire AG is online.

But after changing parameters values how to bring Listener offline and online. and AG offline and online
Can someone please guide me with the steps?


always-onsql server 2017availability-groups
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
anthony.green avatar image
anthony.green answered

Within the failover cluster manager, you can take the role offline, the online again.

3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SaiVijaya avatar image SaiVijaya commented ·
If I take role offline and online in primary will it effect any database synchronization or AG sync
0 Likes 0 ·
anthony.green avatar image anthony.green SaiVijaya commented ·
Taking the role offline yes it will. But you detailed to take the AG offline and online as well as the listener

For just the listener, you can just take that one resource offline and on again in the cluster manager.

0 Likes 0 ·
SaiVijaya avatar image SaiVijaya commented ·

It worked. Thank you so much!

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.