Sql 2000 raid config | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sql 2000 raid config

Hello all i have a question about the setup of raid drives for an sql server 2000 I have a Compaq G3 server (dual processor,2gb ram) I have setup a Raid 5 with 4 disks 18gb each, one spare. The machine runs sql server 2000 A red light is lit on one of the disks (not the spare). This has happened before and i didnt give attention back then and lost data (of course) Now, the red light is flashing again.And sometimes it is off.Whats going on? Does this mean that the disk has errors and i shall remove it for ever? If i remove it i am left with 3 disks (1 spare).
What configurations must i make to these 3 disks on raid then? Thank you all

i suggest you read the user’s manual for your raid controller
go to the hp website, the doc is downloadable, you just have to search for it,
there are also good technical white papers on the raid levels supported by hp controllers
Also, look at the RAID controller software installed on the server. HP RAID control software is about the easiest in the industry. It will tell you what RAID levels you are at, if the hot spare is in use, etc. You should be able to figure things out from there. If in doubt….call HP support. Since it’s a G3, it is probably still under a support contract. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Have you contacted the hardware vendor for any help?
Any information or warnings on the event viewer & vendor’s log? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.