I do not believe any data consistency checks are performed on this server. The SQL data is backed up daily but there are a lot of other files on the server that are likely backed up somewhere. I'm not the normal caretaker for this machine, it has fallen to me because the caretakers are out of town for a few weeks. Naturally the server has run fine for four+ years until yesterday.
The machine indicates it is RAID 5 when viewing the logical drive configuration area.
Drive two does spin up and is green like the others and the logical drive config area shows it being okay. I'd entered the F2 option ( which warned there could be data loss ) where the machine was originally stuck after power cycling several times. The machine seemed to drive two back to life. The RAID config area now shows all drives being okay.
I've learned that drive two had turned orange early in the day that it died. It was several hours after this was first noticed that the machine stopped answering its SQL duties and I was contacted to come over and see what I can do with it.
Main Topics
Browse All Topics





by: dlethePosted on 2009-11-04 at 18:46:52ID: 25746327
First, do you run regular data consistency check/repairs? If not, then you *could* have a catastrophic problem where you have a bad block at the beginning of one of the surviving disk drives. If that is the case, (1 dead drive, and an unrecovered read error), then part of stripe #0 is unrecoverable.
Anything of use in any event logs? Does drive #2 even spin up? If you plug that drive into another PC (don't leave the BIOS, just see if the bios in another PC sees the disk).
Are you 100% sure you configured RAID5 and not RAID0? I only ask because I've seen this problem before.
The RAID should not have disabled the LUN on a drive failure. It will do that on a double drive failure, or if you didn't have RAID5 configured.
No matter what it should be recoverable, even if it means spending $500+ on data recovery firm to get the #2 disk data back, assuming it isn't a full media loss.