Case:
When a user performs data maintenance, there is no operation. The data initializes the data in Kingdee Cai Software. Because it has not been backup this year, all financial vouchers have been lost this year.The engineer inspection by the line data recovery center was detected in the SQLServer enterprise manager. It was found that the operation of the software was to make nearly 300 tables of Drop with the same name of the same name.After analyzing the MBT file, it was found that SQLServer had deleted the ID of the delete table, and the newly created table re -created a new ID.
Solution:
Data recovery solution: Back up the MDF file to prevent destruction from entering one by one.2 The field analysis is performed on the deleted table.3 By analysis of MDF bottom measurement data and match the table structure.4; By matching the program, find all the original ID of the delete table.5 Through the ID and new table structure, the data is extracted to generate the SQL script.6 Add SQL scripts to the new database.7 Migrate the data of the unstained table.Restore successfully.