Media Information:
IBM Server
Fault Description:
An IBM server located in a business unit in Qingdao suffered a failure, storing critical financial data. The incident occurred at the end of the month, when the customer was dealing with urgent financial reports involving 100,000 records. After consulting several data recovery companies in Beijing, the customer chose Das Technology and immediately flew to Beijing on the same day for immediate assistance.
Troubleshooting:
Upon receiving the server, our engineers conducted initial tests on the first five hard drives. The results indicated that three of the drives had varying degrees of bad sectors. We communicated with the customer, who confirmed that the most important data consisted of two sets of accounting books. These could potentially be recovered from backup files (.BAK) or the physical database file (.MDF).
Data Recovery Process:
Option One:
Considering the urgency and the customer’s requirements, Das Technology engineers opted to analyze the RAID configuration and reorganize the data. If the two sets of books were not affected by the bad sectors, this approach would significantly improve recovery efficiency, avoiding unnecessary time spent on full disk mirroring. After reorganizing the data, the .BAK files from August 28 and July 28 were successfully verified in the customer's environment, and the data was confirmed to be 100% normal.
Option Two:
During further communication, we learned that the last backup for one of the accounts was from July 28. However, the latest month’s updates were stored in the physical file B.MDF, which was partially damaged due to bad sectors. The system reported an IO error, making direct extraction impossible. At this point, disk cloning was the only option, but it would take a long time and the customer couldn’t afford delays.
Das Technology engineers analyzed the database layout across the disks and implemented a local mirroring strategy. They identified the start and end positions of the mirror, skipped the bad sector (JUMP10), and adjusted the log after mirroring was completed. This allowed us to extract all recoverable sectors effectively.
After mirroring, the B.MDF file was extracted, but attaching it to SQL Server 2008 failed. Simple logless attachment and repair attempts were unsuccessful, as the database index table pages were damaged. However, since only about a month’s worth of data was missing and primarily concentrated in three key tables, Das Technology used its proprietary SQL repair software to recover all the data in those tables, resulting in a successful recovery.
Data Recovery Results:
Most of the critical data was successfully restored, including both the backup files and the essential database information.
Advice to Customers:
If your server fails, avoid making any unnecessary changes. Always contact a professional and formal data recovery company to ensure the best chance of retrieving your data safely and efficiently.
Up And Down Manual Awning,Manual Roll Up Awning,Manual Camper Awning,Manual Retractable Awnings
Hebei Charlotte Enterprise Co., Ltd. , https://www.hbcharlotteawning.com