Shulou(Shulou.com)05/31 Report--

This article will explain in detail about the solution that the SQLServer database is in a state of recovery and suspension. the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

I. Summary

If the database is in a recovery-suspended state, and the database is offline and separated, the inaccessible error of the database file is reported, which may be because the data file and log file of the database are connected normally. The disk where the files are located is offline, so that the database cannot find the database files within a period of time, and the database is placed in a recovery-suspended state. So after the disk is online, restart the database service, re-find the data file and log file, and the database will be available.

II. Processing steps

1. Database recovery hangs

2. The reason for the recovery hang

The reason for this in my database is that my database data files and log files are stored on storage. At that time, the storage upgraded microcode, so temporarily take the storage disk mounted on this machine offline (offline microcode is fast). After the storage microcode is upgraded, the disk is online again, restart the machine, and the database service is automatically restarted. Log in to the SSMS client. To check the status of the database is to restore the suspended state.

3. Processing steps

(1) failed to try restore database, indicating that the database is offline

Script: restore database run with recovery

(2) perform offline operations on the database and report errors

Note: if the database can be offline successfully, it is also possible to go online again, depending on what causes the database recovery to hang.

(3) when the database is separated, the same error is reported.

Note: the error that the database file is not accessible is reported above for database offline and separation. Look at the disk file and find that the file exists.

(4) had no choice but to restart the database service.

Note: after restarting the database service, I found that the database is ready and ready to use, and it is done!

So much for the solution that the SQLServer database is in a recovery-pending state. I hope the above content can be of some help and learn more knowledge. If you think the article is good, you can share it for more people to see.

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.