Post reply

Enable\Disable AG Listener

  • July 3, 2014 at 1:26 am

    #308862

    Hi Experts,

    How can one enable\disable Availability Group listener? I know AG listener can be deleted and added but didnt find anything to disable or enable that.

    Please help

    TIA

  • July 3, 2014 at 4:41 am

    #1726732

    The listener cannot actually be stopped or started, it can be deleted or restarted. If you stop the IP or VNN cluster resources you'll take the AlwaysOn group offline so i wouldn't recommend that unless you really want the group offline.

    Just delete the listener and add it back when you need it, this can be scripted in T-SQL to make it more streamlined

    ALTER AVAILABILITY GROUP group_name REMOVE LISTENER ‘dns_name’

    ALTER AVAILABILITY GROUP group_name ADD LISTENER ‘dns_name’

    WITH IP ( ('ip address','subnet_mask') ) , PORT = tcp_port_number

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply