Case:
When the user performs data maintenance, the data is misused and the data initializes the data in Kingdee’s financial software. Because it has not been backup this year, all financial vouchers have been lost this year.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.
Solution:
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.Use 10 hours to recover the successful power 99% 24-hour service hotline: 4006-759388