Windows 2003/IIS & SQL 2000 Disaster Recovery
Closed     Case # 10003     Affiliated Job:  American Systems Consulting, Inc.2
Opened:  Unknown     Closed:  Unknown
Total Hit Count:  17232     Last Hit:  Tuesday, July 23, 2024 11:47:13 AM
Unique Hit Count:  5361     Last Unique Hit:  Tuesday, July 23, 2024 11:47:13 AM
Case Type(s):  Database, Server, Client Project, Vendor Support
Case Notes(s):  All cases are posted for review purposes only. Any implementations should be performed at your own risk.

Client Project: Dell PowerEdge server with internal storage on a SATA CERC controller in a RAID5 configuration.

Server collapse after multiple drive failure. Due to no backup of the system, client requested to recover any data available.

Diagnostic process included contacting Dell support who said nothing could be done and shipped out a replacement RAID controller and three hard drives. I replaced the CERC controller and reattached the existing drives in the proper order - forced the drives back into the original RAID5 configuration and into an online state - I was still unsuccessful to boot the system, but was able to image off the data to my laptop via Symantec Ghost - rebuilt the server and restored what data I could from this image - including the SQL databases.

The databases were placed onto the newly built system replacing the system databases and adding the others - brought the SQL server into a single user mode and extracted what data that could be recovered. Apart from some inconsistencies, nearly all data including the web site scripts were successfully recovered or recreated.

Profile IMG: Footer Left Profile IMG: Footer Right