How can I remove the Read-Only Routing URL in an availability group.
I have set the Read-Only routing URL and I'm trying to get it back to how it was before my test and I can't find a way to remove those URL.
I tried with :
ALTER AVAILABILITY GROUP [AG1]
MODIFY REPLICA ON
(SECONDARY_ROLE (READ_ONLY_ROUTING_URL = N''));
but SQL does not allow an empty value here.
Thank you for you precious help.