4

I have two Microsoft SQL Servers (v 2012) and I want to make them mirror and when one of them goes down the second one will be replaced.

AlwaysOn is a new feature in SQL Server 2012 that is designated to High availability solutions. I must say that I don't have SAN.

Is it possible to create high availability in this scenario? What is the best solution without SAN?

masegaloeh
  • 18,236
  • 10
  • 57
  • 106
Pooya Yazdani
  • 277
  • 5
  • 12

1 Answers1

4

The AlwaysOn feature (more appropriately called availability groups as "AlwaysOn" is the generic term for HA that also includes failover clustering) that you mention can be set up in a "share nothing" scenario. Which is to say that you don't need to have a SAN at all since the disks for each server can come from anywhere. You just need two 2012 enterprise edition instances and you can start setting it up.

Ben Thul
  • 3,024
  • 17
  • 24
  • I studied about AlwaysOn and it is stated that this feature is available to use in public cloud for a scenario without SAN? Is using public cloud a must? – Pooya Yazdani Dec 24 '13 at 12:34
  • 1
    Where idid it state that? I did not find that (ridiculous) statement anywhere. – TomTom Dec 24 '13 at 14:26
  • 1
    I sure hope not as I have it configured just this way in my on premises environment. – Ben Thul Dec 24 '13 at 15:34