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 |
|
Ling
Starting Member
4 Posts |
 Posted - 2009-03-17 : 18:46:23
|
| Hi All, As we know Raid 0 does not provide fault tolerant, but how comes if Raid 0 has 2 disks? I got the question from TestKing, volume E Raid level is RAID-0, Disk size is 2x20GB, the transaction log must be stored on a fault-tolerant volume, and the answer is to store transaction log in volume E. I am confused about this, does that mean if Raid-0 has 2 disks, it can provide fault tolerant? hope someone can help. Thanks a lot, Ling |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-03-17 : 20:56:18
|
| RAID-0 is not only not fault tolerant, it has a higher risk of failure than other RAID types. The data is striped across the available disks, so you get the fullest capacity of the drives. However, if a single drive fails, the data cannot be reconstructed from the remaining drives.If this was a test, the tester is either an idiot, or they didn't review their answers. |
 |
|
|
|
|
|
|
|
Raid 0 and falut tolerant