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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2006-09-14 : 01:41:16
|
| Herer is our current disk configuration for the machine that will have a SQL server 2005 on it. Does it look ok? what is the best place to back up the database? and transaction log file . what is the best raid configuration for that? Volume1 RAID-1 72GBC: Drive OS 16GBD: Drive Applications 56GBVolume2 RAID-5 560GBE: Drive Databases 560GBVolume3 RAID-0 280GBF: Drive TransLogs 280GB |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-14 : 07:28:02
|
| Ideally you need 4 channels:O/SMDFLDFBackupsIf you only have 3 then I reckon you should put the backups on the LDF channel - if you get a corruption that kills the MDF your Transaction log backup on the LDF channel will quite likely be fine, so a restore from last full backup and all Tlog backups should get you back upright again (indeed, if you can successfully take one final TLog backup first you will lose nothing!)Either way put LDF and MDF on different channels, and use LDF channel for backups if you don't have yet-more channels.RAID5 trashed my database (i.e. MDF file) - a drive went down during a write operation and the system failed to complete the write to the other drives, so I reckon RAID5 is as good as useless for that job. I see RAID10 being recommended, but I don't know if that would have saved me in the above scenario.Kristen |
 |
|
|
|
|
|
RAid configuration and backup