"Data Recovery failure description"
Company financial personnel for data maintenance, misoperation, in the financial software to initialize the data, because recently did not do backup, it caused a lot of financial documents lost.
Because the financial data is very important, the customer is anxious to get back.
The data Recovery Analysis "
Engineer detection, in SQL Server database Enterprise Manager, discover what the software does is drop the data table and re-creat the table with the same name. After analyzing the MDF file, it is found that SQL Server has deleted the ID of the deleted table, and the newly created table has re-created the new ID.
"Data recovery process"
1. Full image of the fault disk, backup the MDF file to prevent two damage.
2. Scan and reorganize the mirror disk to perform field analysis on the deleted table.
3. The MDF is analyzed by the underlying data and matched to the table structure.
4. The original ID of all deleted tables is found by matching the program.
5. The data is extracted by the ID and the new table structure, and the SQL script is generated.
6. Attach the SQL script to the new database.
7. Migrate the data for the non-deleted tables.
"Data recovery results" through an engineer's overtime extraction recovery, customer verification data, recovery data success
Important Reminders
When important data is deleted or lost, the computer should be shut down immediately to prevent the loss of data from causing more serious damage.
important data must be well backed up. Take care to delete, confirm that data is no longer required or is ready to be backed up!
Speed up software/housekeeper software/UF software/Kingdee software/Catering software/financial software database repair/Data initialization recovery