I am looking at HA options for SQL 2012 Standard.
I like the look of AlwaysOn FCI. I am using a SAN, so I think I can meet all of the requirements, but one of the applications I am looking at cannot have an alternative DB configured, only a single database location.
With FCI, is there any way to create a single name (ie SQLCluster01.domain.com) which will respond whichever node is up?
If not, is there any other way of creating a high availability access point for the databases?

  • 1
    High availability and load balancing are different things. Which are you trying to accomplish? – joeqwerty Mar 24 '16 at 19:45
  • I have clarified the point. I am trying to accomplish HA – mwiggs Mar 30 '16 at 18:30

When you setup AlwaysOn, it is backed by Windows Clustering. As part of the setup you'll create a Cluster IP Address and host name and that is how you will connect to the active instance. The IP will move depending on multiple factors in Windows Clustering and AlwaysOn.

This is only for fail over, if you want load balancing you'll have to look at AlwaysOn AGs and your options there.

  • I am using Windows 2008 R2 Standard so do not have Windows Clustering. Are there any other options? Any third party tools that can achieve a similar result? – mwiggs Mar 30 '16 at 18:36

With an FCI, there is only one SQL instance (as opposed to an Availability Group in which you have multiple instances participating in a primary/secondary relationship). You connect to it via the cluster name that does the right thing (i.e. routes the request to whichever node in the cluster currently owns the instance).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.