topic Windows 2008 R2 and SQL Failover Cluster with Shared Storage on Lefthand SAN in StoreVirtual Storage

Windows 2008 R2 and SQL Failover Cluster with Shared Storage on Lefthand SAN

CSFEUS — Tue, 26 Feb 2013 03:04:06 GMT

We will be setting up a few Windows 2008 R2 servers with SQL, Failover Clustering. We would like to use our Lefthand SAN as shared storage for our sql databases. Not quite sure how to setup the shared storage. Do we setup the san space on each server before doing the cluster? Any documentation or help with setting up the SQL shared storage with the Lefthand SAN would be appreciated.

Re: Windows 2008 R2 and SQL Failover Cluster with Shared Storage on Lefthand SAN

IainS — Tue, 26 Feb 2013 21:03:42 GMT

Stop being lazy and do a lot of reading. There is tons of documentation about this from HP and on the wider internet. You need to have quite a bit of background knowledge to make it work and keep it working as this stuff isn't that easy and quite a bit can go wrong. Read about CSV volumes and it might also be worth considering Window Server 2012 which seems to do this stuff better (but we aren't yet using live).

If you don't want to do the necessary reading then pay someone else with experience to do it. Keep in mind that you'll probably want them back again so it's not just a one off cost.

Re: Windows 2008 R2 and SQL Failover Cluster with Shared Storage on Lefthand SAN

CSFEUS — Wed, 27 Feb 2013 01:50:15 GMT

We did. .... Thanks for the help..... You must be management.... They love paying someone else..... Have a nice day....