Speed up software/housekeeper software/UF software/Kingdee software/Catering software/financial software database repair/Data initialization recovery

Source: Internet
Author: User

"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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.