MS SQL Log and Data files

Posted on 2011-10-23
Last Modified: 2012-06-27
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  How do you do it ?
Question by:GD_GRAY
    LVL 13

    Accepted 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

    Author Closing Comment

    Sorry was away. Thank for your advice.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now