SQL Clustering Options

Hi

SAN is fully supported by MSCS, as long as it is on the HCL.
NAS is not. Look at
<a rel="nofollow" style='text-decoration: none;' href="http://support.microsoft.com/default.aspx?scid=kb;en-us;304261" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;304261</a>

Regards
Mike

"Mike Hodgson" wrote:

 > Can't point you to any doco off the top of my head, but I can say
 > definitively that SQL 2000 running on an MSCS cluster can indeed talk to
 > a SAN regardless of how many SQL instances you have on your cluster.
 > Typically people either have a single instance (which most people refer
 > to as "active/passive") or 2 instances (which most people refer to as
 > "active/active") that they try to keep on separate nodes of the
 > cluster. But you could have up to 16 instances running on a single
 > cluster node - the number of instances doesn't really matter.
 >
 > Basically, all cluster aware SQL server needs is a shared disk to write
 > data (& log) files to. Whether this is a NAS device or a SAN device is
 > irrelevant to SQL server - that's managed by MSCS, not SQL. We've been
 > running several "active/active" SQL clusters on top of MSCS talking to
 > both HP & EMC SANs (as well as HP & Dell NAS arrays) for over 4 years
 > now. It all works fine.
 >
 > As I said I don't have doco on it but I'm sure it wouldn't be too hard
 > to find cruising around the Microsoft website.
 >
 > --
 > *mike hodgson* |/ database administrator/ | mallesons stephen jaques
 > *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907

 >
 >
 >
 > TABMCSE wrote:
 >
  > > I have read that SQL Server with MSCS supports an Active/Active setup
  > >via a NAS, however, DOES NOT support and Active/Active setup via a SAN. Can
  > >anyone shed light on this? Any support documentation that would help would be
  > >great! Thank you