SQL Recovery Mode Database

0

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?

    
asked by anonymous 27.01.2017 / 00:47

1 answer

1

According to this DBA Stack Exchange response :

You are running Crash Recovery , possible causes:

  • SQL Server restarted manually, due to a server crash or start / stop
  • A serious error occurred in the database, forcing it to shut down to recover
  • Someone used the command RESTORE WITH RECOVERY
  • The auto-close option is set, causing the bank to shut down when the last one user exits, and causing a reboot when the next user connects.
  • I recommend you read the answer in English, but I think it helps:)

    If it is taking too long to recover and it does not seem to have activity, you may have to restore through backups. And if you're brave, read on how to recover / repair suspicious databases .

        
    27.01.2017 / 01:16