General discussion


SQL Clustering

By parth ·

I have 2 Pentium Machines. I have one NAS (windows 2003) box.
I am trying to implement SQL 2000 in this cluster for failover.
How should I do it.
As far as What I have read about SQL server in cluster is to have SAN .
But in given above scenario , is it possible to implement SQL server for failover?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by erikdr In reply to SQL Clustering


Windows Cluster Server is what you will activate, and that works with NAS as well as with SAN or iSCSI. Of course for active-active working a NAS is usually a bit slow, but for active/passive why not?
If you find MSDN resources that specifically tell it's not possible please inform me, the ones I researched when I reviewed SQL scalability last month definitely allow NAS...



Collapse -

by p.j.hutchison In reply to SQL Clustering

Storage from SAN or NAS should appear as local drives on each of the servers. Not networked or mapped drives.

Collapse -

iscsi and NAS for clustering

by grant In reply to

I am testing a ReadyNAS with different shares, mainly NFS and a VMware appliance called "iscsi Ent Virtual". It is a bugger to configure but I can see the drives locally on the SQL server and clusteing works.

The alternative is buy a NAS that has iscsi already built into it.

Another alternative is to build something like a Ubuntu box with iscsi connectivity and mount the NAS drives in Ubuntu.

Related Discussions

Related Forums