Case:
During the data maintenance, the data was initialized in the financial software of Kingdee. Because it did not make a backup this year, all financial vouchers were lost this year.
Solution:
After testing by our engineer, in the SQL Server enterprise manager, it was found that the operation of the software was a table with the same name of the nearly 300 tables and the same name.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 98%.