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 characters needed characters left characters exceeded

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

1 Answer

· Write an 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 characters needed characters left characters exceeded

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

If I take role offline and online in primary will it effect any database synchronization or AG sync
0 Likes 0 ·
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 ·

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.