Recover after a Raid-5 disc fault

Hi,

My raid-5 server failed because one disc, some folders and files are lost, but I have recoverd whit some software for the propuse.

I have reinstaled the SQL server and attached the database, but when I try to open the tables I recieve a error message saying : internal consisty error... somethihg like this.

How can a restore the databases?

OK, several things here.

A failure of one disk in a RAID-5 set shouldn't cause any data loss at all. That's what RAID-5 is about: supplying the redundancy such that a disk failure does not equate to a data loss. This means that there must be something else going on to cause your data loss. It should be a very high priority to figure out exactly what happened so that after your database is back online, you can be comfortable that this won't happen again.

The message about an internal consistency error should be investigated initially with DBCC CHECKDB. That should tell you what the problems are and how severe they are. You then have the option to either attempt a repair of the database which usually involves LOSS OF DATA, or you can restore from your most recent backup. What is your backup plan/schedule? Are you in full recovery mode, or simple recovery mode?

Kevin Farlee

|||

Kevin Farlee wrote:

OK, several things here.

A failure of one disk in a RAID-5 set shouldn't cause any data loss at all. That's what RAID-5 is about: supplying the redundancy such that a disk failure does not equate to a data loss. This means that there must be something else going on to cause your data loss. It should be a very high priority to figure out exactly what happened so that after your database is back online, you can be comfortable that this won't happen again.

The message about an internal consistency error should be investigated initially with DBCC CHECKDB. That should tell you what the problems are and how severe they are. You then have the option to either attempt a repair of the database which usually involves LOSS OF DATA, or you can restore from your most recent backup. What is your backup plan/schedule? Are you in full recovery mode, or simple recovery mode?

Kevin Farlee

What happened is that with RAID 5, one disk is the parity drive, so once you lost the parity drive, performance should have been severely degraded, but as Kevin says, you shouldn't have lost everything. If you lost two drives, that's when you lose everything. So are you sure you only lost one drive?