Comparison of Data Recovery Tools

In December 3, The RAID card of the company's server broke down and the backup system also failed for more than a month. Currently, the databases on the hard disk are considered abnormal by SQL. First, you can use the emergency repair mode to append the request. The other one is not so good. During restoration, the system always prompts "the file ***. MDF header is not a valid database file header. The pageaudit attribute is incorrect ."

I have been searching for a long time and found that there are few Chinese documents. I found someone introduced sqlrecover, and then I went to find four tools that could read pageaudit incorrectly, they are:

Systools SQL recovery 4.4, feature: When displaying data, it is not supported for Chinese, only Unicode is displayed, and data can be exported only after registration.

The recovery for SQL Server in officerecovery is characterized by generating corresponding SQL statements instead of displaying data. The problem is that if the data is incorrect, we do not know why it is wrong, therefore, we have no initiative. In the family, there is also a tool named "recovery for outlook" that successfully fixed the incorrect Outlook Express mailbox yesterday.

Kernel for SQL database is restored better, and the results are also displayed in the form of tables, so that I can use my ownProgramRead the data, but the unregistered version only displays 5000 rows of data. In this way, some of my tables cannot be obtained. In addition, the date is displayed in a foreign manner, which adds someCodeAnd at AM.

Stellar Phoenix SQL recovery V2.0, which is similar to kernel for SQL database, can be recovered if it is less than 24 GB. The recovered data is also displayed in a table. Yes, it basically meets my current needs.

The following is a tool that reads and writes the content of the listview control to the database. However, the missing files on the hard disk still cause data errors and loss. The key is backup.