Looking for some feedback on the best raid setup for an SQL database we will be migrating. I procured a new Dell R720 Server with 64GB RAM / two 8 core Xeon 2.9ghz Processors with 6 15K SAS drives 600GB a piece.
Originally I went with using 5 drives in a RAID-5 array with a hot-spare configured. Then I started second guessing myself about the need to keep transaction logs separate on different physical disks in-case of the worst case scenario. RAID-5 will allow me 1 drive failure, and the added hot-spare. But Should I be considering using a RAID-10 setup? This is a school lunch program used by 4 schools so not heavily intensive, but I'm more concerned about backups, and data integrity.
Or should I do 2 drives as my OS and hosting the SQL Server in a RAID-1 configuration, and then use the remaining 4 as my second drive letter in a RAID-10 configuration housing my transaction logs? Lot's of options, and each has its pros/cons. Anyone care to offer their expertise/opinion?