Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2004-03-28 : 14:00:41
|
| If I am running raid 5 on my servers do I need to have my log files on a separate disk drives from my database files?All help appreciated. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-28 : 14:05:48
|
| You don't have to. It depends on your available resources and the utilization on your drives. It's always perferrable to do the following if you can:Data (RAID 5)Log (RAID 10) -RAID 10 will give you a much better write speed than RAID 10. -This also breaks apart the heavily sequential writes of logs from the heavily random reads/writes of data. -I would assume you are using full recovery mode here and doing transaction log backups. Is this correct.-Also, if you can afford it, it's always good to break the tempdb off into it's own disk space.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
LearningSQLDBA
Starting Member
10 Posts |
Posted - 2004-03-28 : 20:26:53
|
| For those individuals whose requirements are to be able to recover their databases right up to the moment of failure, your best bet is not to have your database files (*.mdf & *.ldf) on the same drive as your transaction log files (*.ldf).LearningSQLDBA |
|
|
|
|
|
|
Separating log files on disks