Enabling AlwaysOn on an existing HA Shared Storage SQL 2012 Cluster

• james.crowther

  Grasshopper

  Points: 18

  More actions

  October 9, 2013 at 9:44 am

  #281115

  Hi!

  I've searched numerous blogs and forums for the answer to this, but cant see to find any info on it (maybe i'm being blind!)

  We have an existing Windows Server 2008 R2 / SQL 2012 Enterprise 2-node Cluster with shared SAN storage.

  I'm looking at the possibility of creating a 3rd node, which wont have access to the shared storage.

  is it possible to enable AlwaysOn on the existing 2node cluster, and adding the 3rd node as part of the AlwaysOn availabilty group?

  I'm thinking it wont be possible but thought i would ask.

  many Thanks

  James

• james.crowther

  Grasshopper

  Points: 18

  More actions

  October 9, 2013 at 9:53 am

  #1657218

  after searching blogs for a few hours - i think i may have just found what im looking for here! http://www.sqlservercentral.com/articles/FCI/92196/

• lkennedy76

  SSChampion

  Points: 13683

  More actions

  October 9, 2013 at 12:26 pm

  #1657280

  yes you can. AlwaysOn can be used with a FCI 2012 as a DR plan. I found an article on this a few months ago.

  http://www.sqlskills.com/blogs/joe/alwayson-architecture-guide-building-a-high-availability-and-disaster-recovery-solution-by-using-failover-cluster-instances-and-availability-groups/

  MCSE SQL Server 2012\2014\2016