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 |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2005-03-17 : 11:51:05
|
| Afternoon allWe have a new database server (MS SQL) with a RAID 10 configuration, and an additional disk for the software. We want to simulate a disk failure to ensure that the RAID is working as it should, and to practice rebuilding the faulty drive. Can anyone tell me where to look for information on creating and testing a backup and disaster recovery plan? Books online is great for info, but I need something that gives step by step directions rather than the theory!Much appreciated!Hearty head pats |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-03-17 : 13:45:05
|
| To test RAID array's I've always just pulled out the disk while the system was on. You'll find out real quick if everything was setup as it should be. Hopefully, You'll have a hotspare which will jump in and start getting it's data from the copy of the one that was pulled. If not, you can put the drive you pulled out back in and it will get synced back up with the rest of the drives. Even though it probably has all the data on it, the RAID array see's it as a "dirty" drive and will rebuilt it completly.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-17 : 16:02:21
|
| I'm going to point out the obvious, just in case :)Don't pull the drive cage completely from the chassis while it is still spinning. Just pull it far enough out to disconnect it. After it has spun down, you can safely remove it completely from the chassis.These things sping at 10 to 15k these days, if you move the drive while it is spinning you may damage it.-ec |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-03-17 : 17:56:56
|
| ^^ What he saidJust pull it out maybe 1 inch or so. Moving it around while it's still spinning could actually kill it :)Let's also be clear here and say don't pull out more than one drive at a time. If you pull the two wrong drives, you could kill your entire array. That would be bad :)Use caution when doing this!!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2005-03-18 : 04:24:09
|
| Thanks for the info guys! I am going to delegate the task of pulling out the drive to someone else, as I don't trust my cack-handedness!!!Hearty head pats |
|
|
|
|
|
|
Simulate a disk failure in a RAID config