Best Practice for SQL 2008 High Availability

[thorwitt]

There are so many ways to get a high availability with MS SQL 2008 like

- vSphere HA

- vSphere Fault Tolerance

- MS Cluster

- built in SQL Server 2008 Enterprise features

- etc.

Anybody got a decision matrix (perhaps an excel spreadsheet) for all the possibilities?

thank....

[AndreTheGiant]

For HA, FT and guest clustering comparison see the notes on:

For SQL HA solutions see:

http://blogs.msdn.com/microsoftbob/archive/2008/06/21/sql-server-2005-high-availability-options-dist...

http://msdn.microsoft.com/en-us/library/ms190202.aspx

Andre

[TimPhillips]

I'mn using StarWind for this. So here is all documentation that you need:

http://www.starwindsoftware.com/images/content/StarWind_SAN_HA_ESX.pdf

http://www.starwindsoftware.com/the-2010-guide-to-iscsi-storage

http://www.starwindsoftware.com/sql-server-clustering-guide

http://www.starwindsoftware.com/microsoft-server-clustering-101-guide

http://www.starwindsoftware.com/hyperv-and-high-availability-shared-storage

http://www.starwindsoftware.com/iscsi-san-for-vmware-esx-and-esxi-data-sheet

http://www.starwindsoftware.com/starwind-enterprise-server-data-sheet

http://www.starwindsoftware.com/starwind-iscsi-san-for-hyperv-data-sheet

http://www.starwindsoftware.com/using-starwind-with-ms-cluster-on-win2008-server

http://www.starwindsoftware.com/using-starwind-with-ms-cluster-on-win2003-server

http://www.starwindsoftware.com/iscsi-san-for-microsoft-exchange-data-sheet