Shulou(Shulou.com)06/01 Report--

This article mainly introduces the sqlserver database encryption can not be used after the use of MDF,LDF,log file name modified data recovery how to do, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian with you to understand.

Fault:

2 SQL server databases are encrypted and cannot be used.

Database MDF, LDF, log log file names have been modified

As shown below:

The database backup is encrypted and the file name is modified. The administrator contacted the North Asia data recovery Center for data repair.

Data recovery process:

1. Back up the database. In order to prevent secondary damage to the original database during the data recovery process, the North Asian data recovery engineer made a backup for each database. All the operations to recover the data are carried out on the backup, avoiding the possibility of damage to the original data.

2. Use the data recovery software developed by North Asia to open the encrypted SQL server database and find that the head of the database has been destroyed.

3. After inspection, the North Asia data recovery engineer determined that the sqlserver database page size is 8K, cut blocks according to 8K size, and look down. Finally, it is concluded that bingdu encrypts the database files every 128K, and the encryption size is 128bytes.

4. The North Asian data recovery engineer opened the database backup and found that it was encrypted every 128K with an encryption size of 128 bytes.

5. Search down for the start flag 00F of the database page, and the North Asian data recovery engineer found that it was not encrypted. After analysis, it is found that the database is encrypted every 128K in the same way as database backup encryption, and the encryption size is 128 bytes. Because the database backup header records the backup information, the database page starts to shift downward, so the encrypted pages in the database are staggered with those encrypted in the database backup.

6. Repair the encrypted database. North Asia data recovery engineer combined with database backup to repair the encrypted pages in the database, append the modified database through the database management tool, and query verification, and then verified by the administrator, the data is no problem.

Thank you for reading this article carefully. I hope the article "how to recover the data that cannot be modified by using MDF,LDF,log file name after sqlserver database encryption" is helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.