Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
AG Listener HA

Answered AG Listener HA

  • Friday, January 11, 2013 8:16 PM
     
     
    Sign In to Vote
    0

    I'm new here, and I'm reading about AlwaysOn feature before implement it. Sorry if my questions doesn't make sense.

    What happens if the AG Listener stays offline? 

    I saw that's possible to have more than one AG Listener, and, in this case, It's possible use LBN or some other feature to automatically redirect to another active listener in front of fails? Or I need give this intelligence to the application? 

    Thanks in advance! 

     

All Replies

  • Friday, January 11, 2013 9:24 PM
     
     Answered
    Sign In to Vote
    0

    Hi,

    Basically a listener consists of a network name cluster resource and a cluster ip, both in the Availability Cluster Group. You can only create one listener per availability group.

    If the listener is offline (and stays offline) then any connections to through the listener will fail, however any connections that go directly to the sql instance/ db will obviously still work since the sql instance will still be online.

    Regards,
    Mark Broadbent.

    Contact me through (twitter|blog|SQLCloud)
    Please click "Propose As Answer" if a post solves your problem
    or "Vote As Helpful" if a post has been useful to you
    Watch my sessions at the PASS Summit 2012