We have a multi-site AG and are demoting one of the remote sites out of the AG. In doing so, we’ve discovered that no logic exists to remove an IP address from the listener. Has anyone else tried this?
It seems that the ALTER AVAILABILITY GROUP MODIFY LISTENER logic lacks functionality other than ADD.
I’m afraid to just remove the IP address from the cluster object as that IP is also stored in the HADR systables.
select * from sys.availability_group_listener_ip_addresses
select * from sys.availability_group_listeners