• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 171
  • Last Modified:

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
0
garystark
Asked:
garystark
3 Solutions
 
dlan75Commented:
Hi,
I would take the solution b with the two first HD for OS setup with RAID 1
0
 
ptjcbCommented:
Solution b is the recommended one. You should have the logs on a separate partition because they require more activity.

0
 
YveauCommented:
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now