+ Post New Thread
Results 1 to 2 of 2
Hardware Thread, SQL server hardware query in Technical; I'm in progress of speccing a server for the SQL upgrade from 2005 to 2008, at present we have a ...
  1. #1

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    22

    SQL server hardware query

    I'm in progress of speccing a server for the SQL upgrade from 2005 to 2008, at present we have a separate disk for the transaction logs but reading around suggests that in SQL server 2008 this is no longer necessary. I wondered what any one else thought

  2. #2
    Duke's Avatar
    Join Date
    May 2009
    Posts
    1,017
    Thank Post
    300
    Thanked 174 Times in 160 Posts
    Rep Power
    58
    I was doing the same thing here the other day: New SQL Server Check

    General advice still seems to be a separate array for the logs. It's as much for security as anything else, so that if the database array fails you can still restore the backups and then play back the logs from the other working array.

    I'm getting RAID1 for the OS and RAID10 for the database. The transaction logs will either go on the OS drive or on a SAN, depending on which gives the best performance.

    Cheers,
    Chris

  3. Thanks to Duke from:

    Hecate (15th March 2010)

SHARE:
+ Post New Thread

Similar Threads

  1. Help With SQL Query Error
    By penfold_99 in forum Coding
    Replies: 6
    Last Post: 15th May 2009, 01:30 PM
  2. WSS 3.0 SQL Query
    By phreak in forum Windows
    Replies: 1
    Last Post: 28th April 2009, 01:06 PM
  3. SQL update query
    By MACIT in forum Coding
    Replies: 4
    Last Post: 27th October 2008, 08:20 PM
  4. SQL Insert Query
    By Pashers in forum Web Development
    Replies: 1
    Last Post: 9th September 2008, 03:42 PM
  5. SQL Query :S
    By Kained in forum Web Development
    Replies: 10
    Last Post: 25th July 2007, 02:56 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •