I am trying to design and implement a server based solution for hosting all our soon to be SQL databases (they are currently MSDE). I would like to know what the recommended design for the RAID is. I was thinking the following:-
RAID 1 - O/S and programs
RAID 1 - LOG FILES
RAID 5 - Databases
I am torn between RAID 5 or RAID 10 for the databases. I am trying to get the balance between cost v performance v redundancy.