MS SQL Server 2005 - Installation question

I have two identical servers that I plan to use for MS SQL Server 2005.  I plan to replicate one server to the other for disaster recover reasons.  My question is about hot best to layout the drives.  There are six drive slots (SAS).  Which of the following would you recommend...

a)  2 for OS, 2 for DB, 2 for logs
b)  2 for OS & logs (separate partitions), 4 for DB (raid 5)

If not one of these, what?

gary
garystarkAsked:
Who is Participating?
 
dlan75Connect With a Mentor Commented:
Hi,
I would take the solution b with the two first HD for OS setup with RAID 1
0
 
ptjcbConnect With a Mentor Commented:
Solution b is the recommended one. You should have the logs on a separate partition because they require more activity.

0
 
YveauConnect With a Mentor Commented:
Yep, B is the one to go for !
Logs (and tempdb !!!) should be separated from the databases. In case of an emergency you don't want to loose both of them, then you are in serious trouble ... Next to that it will slightly increase performance in most situations ...

Hope this helps ...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.