Server 2003 raid setup advice

**Anilrgowda** · 05-Jun-2007, 01:12 AM

I am rebuilding a server for a new application we will be running and need some advice on the raid setup. I don't have alot of experience with raid but I do know how to configure it.

On this server we will be running Server 2003, SQL 2005, an application called E-Automate, and eventually another app called Compass Opportunity Manager. Both apps use SQL for their database. I have 5 drives in this dell server and would like advice on setting up the raid for fault tolerance.

Should I do like 2 drives mirrored for the OS and 3 drives raid 5 for the apps?

**Anilrgowda** · 05-Jun-2007, 01:12 AM

With 5 drives that would be the optimal configuration:

Drive 0 - Mirror
Drive 1 - Mirror - These two will host your OS

Drive 2 - RAID5
Drive 3 - RAID5
Drive 4 - RAID5 - These three will host your SQL data

This gives you a quick os/application recovery if you lose a mirrored drive and decent recovery time for the data side (keep a spare drive on hand if possible).

05-Jun-2007, 01:12 AM	#1 (permalink)
Anilrgowda Administrator Posts: 18,720 Join Date: Jan 2006 Rep Power: 10 IM:	Server 2003 raid setup advice I am rebuilding a server for a new application we will be running and need some advice on the raid setup. I don't have alot of experience with raid but I do know how to configure it. On this server we will be running Server 2003, SQL 2005, an application called E-Automate, and eventually another app called Compass Opportunity Manager. Both apps use SQL for their database. I have 5 drives in this dell server and would like advice on setting up the raid for fault tolerance. Should I do like 2 drives mirrored for the OS and 3 drives raid 5 for the apps?

05-Jun-2007, 01:12 AM	#2 (permalink)
Anilrgowda Administrator Posts: 18,720 Join Date: Jan 2006 Rep Power: 10 IM:	Re: Server 2003 raid setup advice With 5 drives that would be the optimal configuration: Drive 0 - Mirror Drive 1 - Mirror - These two will host your OS Drive 2 - RAID5 Drive 3 - RAID5 Drive 4 - RAID5 - These three will host your SQL data This gives you a quick os/application recovery if you lose a mirrored drive and decent recovery time for the data side (keep a spare drive on hand if possible).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)