SQLServer database based data recovery method

Abstract

The invention discloses an SQLServer database based data recovery method, comprising the following steps: S1: determining a data table of a database; S2: obtaining all information of the table; S3: obtaining a logic structure relation of records; S4: obtaining specific information of fields; S5: obtaining data recovery logic structure features; and S6: forming a data table form by data and performing extraction. The method has the beneficial effects as follows: an SQLServer analyzes the records and the fields in the data table through a database structure; the head of each record and structure division data of the fields are found and extracted; the data recovery efficiency is high; a fragment-grade database with corrupted and discontinuous data also can be subjected to normal extraction and recovery; the success rate of data recovery is high; and the loss caused by database damage is effectively reduced.

Description

technical field [0001] The invention relates to the technical field of information security, in particular to a data recovery method for a SQL Server database. Background technique [0002] SQL Server is a relational database management system launched by Microsoft Corporation. It has the advantages of convenient use, good scalability and high degree of integration of related software. SQL Server is a comprehensive database platform that provides enterprise-class data management using integrated business intelligence (BI) tools. [0003] The SQLServer database engine provides a more secure and reliable storage function for relational data and structured data, enabling you to build and manage highly available and high-performance data applications for business. A database consists of various components, including tables, views, stored procedures, records, fields, indexes, and so on. [0004] However, database failures sometimes occur, resulting in inaccessible data. The co...

AI Technical Summary

Problems solved by technology

[0004] However, database failures sometimes occur, resulting in inaccessible data. Among them, the common reasons for database corruption are as follows: Transaction log problems

For example, the transaction log file is lost; the transaction log file is deleted by mistake during the operation; The database is shut down abnormally while being read and written; the table of the database is damaged or the index is damaged, or other objects of the database are damaged or lost; the data file is deleted or its name is changed; the hard disk is damaged, causing data and Log file read and write errors, etc.; some of these errors can be handled by the database itself through disaster recovery mechanisms to ensure normal data access, but for database table damage, database deletion, or data file deletion, the database itself cannot be repaired at this time. A special method is needed to solve these problems. Most of the solutions are to restore the lost database files, and then restore the records. However, if the files are stored in fragments, there are some methods to restore the database on the market. In this case, it is necessary to use the method of recording characteristics to complete data recovery, so as to preserve the integrity of key data to the greatest extent.