Good afternoon, A database is in "In Recovery" status. When attempting to parse the error log through this dbcc checkdb command, it returns the following error message.
Database is beeing recovered. Wait until recovery is finished.
Does this mean that SQL Server itself is restoring the database automatically?
CONFIRMED: SQL starts and ends the recovery process on its own. And the database is inaccessible in this 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 into recovery mode.
I tried to check the list of pending processes using SP_WHO2, and have only two CHECKPOINT processes that appear constantly.
The server is idle, unused.
This problem occurred after the server rebooted during a process that changed a table of 70 million records.
How do I solve this problem?