Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

MS SQL Log and Data files

Ok this may be a dumb qiestion but, if I have RAID 1 setup on my server how would /or can I setup SQl Server to place the Log Files and Data Files on a different physical partition for each ? My only thought is to dedicate 2 drives outside the array for the files and than store the backups in the array ???? Maybe this is just simple minded...lol  How do you do it ?
1 Solution
Well, if you don't have separate drives/arrays, it means you don't have separate drives/arrays :)

Log and Data files require different patterns. Log needs sequential read/writes and must be protected (if log is corrupted, you're stuck). So Raid-1 is the perfect choice for the log. Data files need to be optimized for random access - e.g. it would benefit from Raid 10 or Raid5. Of course, backups would be better to store on the separate drives as you already mentioned.

Last, but not least, put tempdb on the fastest drive possible. You can even use RAID-0 for it if needed (if drive is corrupted you'd have your server down but you don't lose any data in such case).

Here is the link to storage best practices article from MS http://technet.microsoft.com/en-us/library/cc966534.aspx
GD_GRAYAuthor Commented:
Sorry was away. Thank for your advice.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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