Case:
When Ms. Luo carried out data maintenance of the company’s financial computers, she misused and initialized the data in UFIDA’s financial software. Because she did not make a backup this year, all the data was lost this year.
Solution:
After being tested by our company’s engineer, in the SQL Server enterprise manager, it was found that the operation of the software was a table that made nearly 300 tables drop Drop and re -CREAT.After analyzing the MDF file, it was found that SQL Server had deleted the ID of the delete table, and the newly created table re -created a new ID.Data recovery scheme:Back up the MDF file to prevent damage to one time.2.Field analysis of the deleted table.3.MDF analyzes underlying data and matches the table structure.4.Through the matching of the program, find the original ID of all delete tables.5.Through the ID and new table structure, the data is extracted and the SQL script is generated.6.Add the SQL script to the new database.7.Move the data of the underser table.After verifying the data of the customer, the successful power is restored by 96%.