Welcome to SqlServer-QA.net Sign in | Join | Help

Business Continuity (SSQA.net)

Business continuity & Contingency planning - essential and unavoidable tasks.
RAID Server Failures And Data Loss Issues!


Recently we had this discussion about what will be situation when there will be a RAID server failure and chances of data loss issue. The common cause for this issue might be a RAID controller failure or configuration changed, Two or more hard drives fail or go offline, Server crashes and won't remount the array or volume(s) due to the virus on the first instance. Also the system must be checked for any configuration chances that becomes corrupt or damaged or adding incompatible hard drives. In my case once there was a problem with the Hardware conflict and that has cause the Software corruption of RAID firmware which instantaly crashed the server where the database has lost the information that store in last 15 minutes.


Instantaly we have recalled the Vendor to rebuild the failed RAID arrays and see any chances of repairing damaged RAID volumes for a recovery of hard drive data, and in worst case we have planned the restore process critical data. Lately we have found that RAID platters are damaged, striping overwritten or changed completely, that has lead to chances of getting data back are thin and lost the critical data causing Business mayhem.

The moral of this story is be prepared for hardware or software loss and never take it granted that the schedule of backup is fine, only test them to ensure that backup is in healthy state.

Posted: Sunday, March 11, 2007 10:18 AM by SQL Master
Filed under: , , ,

Comments

SQL Server Security, Performance & Tuning (SSQA.net) said:

What kind of database maintenance operations you should be doing when you are DBA? You should have better

# December 3, 2007 11:53 AM
Anonymous comments are disabled