How to restart SQL listener after changing RegisterAllProvidersIP and HostTTL

Question

Hi Team,

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
   Please guide me with the steps?

With AG offline and online, will it affect in secondary AG's. How Secondary servers will behave with this change.

Answer 1

Hi @Sai ,

>But after changing parameters values how to bring Listener offline and online and AG offline and online
>Please guide me with the steps?

You can using below PowerShell scripts;

Stop-ClusterResource yourListenerName  
Start-ClusterResource yourListenerName  
Start-ClusterGroup yourListenerGroupName  

Or you can do this from failover cluster manager as below screenshot.

>With AG offline and online, will it affect in secondary AG's. How Secondary servers will behave with this change.

Yes. The AG will be in a resolving state as below screenshot until you bring SQL AG online.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.