Friday, January 11, 2013 8:16 PMI'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!
Friday, January 11, 2013 9:24 PM
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,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
- Proposed As Answer by Sean GallardyMicrosoft Community Contributor, Editor Saturday, January 12, 2013 5:29 AM
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Tuesday, January 22, 2013 8:34 AM