SQL 2000 Cluster

[adfreek]

Hello,

We have two new Dell 2850 servers which we're planning on using for a two node active/passive SQL 2000 cluster to a back end NetAPP. I was wondering if anyone could provide some experience or online links that I can review which include the steps to configuring the cluster then installing SQL on the Cluster? Any good white papers out there?

Many thanks

 

[yelworcm]

Here is a start:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

then you can take your pick from these:

http://search.microsoft.com/search/results.aspx?st=b&na=88&View=en-us&qu=build+SQL+cluster

 

[mrdenny]

NAS devices (such as NetApps) aren't supported for Clusters or for SQL. You have to have shared direct attached storage from a SAN or a dual homed SCSI inclusure such as an HP MSA1000.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[adfreek]

We are using a NetAPP SAN - FAS270C using iSCSI

 

[mrdenny]

You should be able to use that for a Cluster. Check the MSKB. They've got some good walkthroughs on setting up the cluster. Setting up a 2003 cluster is pretty easy.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[adfreek]

Just heard a rumor that the NetAPP only does RAID 4? That's wouldn't be ideal for SQL database files, correct? I would think RAID 10 (0+1) or RAID 5.

 

[mrdenny]

That is correct NetApps only use RAID 4.

Because of the amount of cache on the head unit they usually don't have problems with write performance.

RAID 4 is basically RAID 5 but with two parity disks instead of one.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com