Sql-server – SQL Server Standard High Availability (HA) with two nodes

failoversql server

Is it possible to accomplish High Availability (HA) with two SQL Server Standard nodes ?

  • We can't use SQL Server 2012 AlwaysOn without Groups as it has single point of failure by using the "single" database file
  • We can't use SQL Server 2012 AlwaysOn with Groups because it's placed in Enterprise package and we don't have license for that
  • We can use any other SQL Server version but in Standard packaging level
  • We can't use mirroring because it requires a third SQL Server used as witness server

Any other suggestions ? I have tried to find an answer all over the internet and didn't find anything.

Thanks

Best Answer

Use Database Mirroring. Witness node is optional.

http://technet.microsoft.com/en-us/library/ms190941.aspx

You may configure a failover cluster with virtual shared storage. There are guys who do the VSAN for Windows (however they call it "for Hyper-V" but don't get confused it works bare metal on Windows as well).

http://www.hotwebclips.com/Home/Show/tGgqG8oEpBQ

Related Question