Windows

General discussion

Gravatar
0 Votes
Locked

SQL Clustering

By parth ·
Hi

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

gravatar
Collapse -

by erikdr In reply to SQL Clustering

Hi,

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...

Regards,

<Erik>

gravatar
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.

gravatar
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.

Back to Windows Forum

Start or search

Related Discussions

Related Forums