SQL Recovery Mode Database

Question

Good afternoon, A database this with status "In Recovery". While trying to parse the error log through this dbcc checkdb command, returns the following error message.

Database is beeing recovered. Wait until Recovery is finished.

This means that SQL Server itself is restoring the database automatically?

CONFIRMED: SQL starts and finishes the recovery process on its own. And the database becomes inaccessible in that period.

Now I have a bigger problem. The SQL service is consuming a lot of memory and is very slow in response time to perform a simple select.

And every time I try to restart the server, the database goes back in Recovery mode.

I tried to check the list of pending processes using SP_WHO2, and there are only two CHECKPOINT processes that appear constantly.

The server is idle, unused.

This problem occurred after the server restarted during a process that changed a table of 70 million records.

How to solve this problem?

Answer 1

According to this DBA Stack Exchange response:

Is rotating the Crash Recovery, possible causes:

1. SQL Server restarted manually due to a server crash or start/stop
2. A serious error happened in the database, forcing it to turn off to recover
3. Someone used the remote RESTORE WITH RECOVERY
4. To auto-lock option is configured, causing the bank to shut down when the last user leaves, and causing a reboot when the next user connects.

I recommend reading the answer in English, but I think it helps :)

If it is taking too long to recover and does not seem to have activity, maybe you have to restore by backups. And if you have courage, give a read on how to recover/repair suspicious Databases.