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 |
|
lebedev
Posting Yak Master
126 Posts |
 Posted - 2009-09-02 : 21:32:15
|
| We are in the process of designing database file organization and RAID levels for the principal and mirror SQL Server instances.Zero data-loss is the main requirement. We can sacrifice database availability, but need to recover from a failure within hours. The database size will grow at a rate of about 2GB per day.Ideally, we would like to have OS and SQL Server files on one RAID set, data files on another RAID set and index files on yet another RAID set. What RAID level would you recommend for each of these RAID sets?How low can these RAID levels go if database mirroring is used (while still ensuring zero data-loss)?I hope these questions make sense. If not, I'd be happy to provide more details.If you don't have time to suggest an appropriate architecture for our environment, please share your own configuration.Thanks.Alec |
|
|
|
|
|
Disk configuration for mirrored servers