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 ...
12th March 2010, 01:48 PM #1
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
15th March 2010, 12:13 PM #2
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.
By penfold_99 in forum Coding
Last Post: 15th May 2009, 02:30 PM
By phreak in forum Windows
Last Post: 28th April 2009, 02:06 PM
Last Post: 27th October 2008, 09:20 PM
By Pashers in forum Web Development
Last Post: 9th September 2008, 04:42 PM
By Kained in forum Web Development
Last Post: 25th July 2007, 03:56 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)