Database in recovery

Question

I have a database currently showing to be in recovery.  I have not been able to find a GUI method to monitor the progress (to determine when it might complete) so is there a command line T-SQL method to monitor the recovery process?

 

Answer 1

If this is 2005, this might be what you need:

 

select der.session_id, der.command, der.status, der.percent_complete, *
from sys.dm_exec_requests as der

 

It works for other types of commands that have known progress indicators.  If not, then I really don't think it tells you.  You might also check the error log to see how long it took the previous time...

Answer 2

Thanks Louis!  It worked fine and the database eventually did recover.

 

Answer 3

Thanks Louis, it works for me too..

Answer 4

I have a database currently showing to be in recovery.  I have not been able to find a GUI method to monitor the progress (to determine when it might complete) so is there a command line T-SQL method to monitor the recovery process?

 

Try MS SQL Database Recovery to recover & restore corrupted SQL Database.

Answer 5

I have a database currently showing to be in recovery.  I have not been able to find a GUI method to monitor the progress (to determine when it might complete) so is there a command line T-SQL method to monitor the recovery process?

 

Try MS SQL Database Recovery to recover & restore corrupted SQL Database.

That is not what the OP asked for... The OP didn't have a corrrupt database.

---

Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi

Answer 6

I think he knew that, but wanted an opportunity to post a stealth sales ad.  Why else resurrect a 2 year old thread with irrelevant info?

---

Michael Asher

Answer 7

<<I think he knew that, but wanted an opportunity to post a stealth sales ad. >>

I figured that, I just wanted to be a bit more... subtle... about it. ;-)

---

Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi

Answer 8

I hate to bump an old thread, but this thread is at the top of Google search results for database in recovery.  

To check the recovery status, look in the server's application event log.  There will be MSSQLSERVER entries with the progress and ETA listed.

Answer 9

Hey don't apologize AFraley that helped me today and this is 7 months after your post.

Answer 10

This was helpful to me.  I found a lot of articles describing what Recovery was, how it worked, etc., but this was the first article I found describing how to check it's progress.  

 

The system logs actually said that the database had finished recovering 7 minutes earlier, but the status still said (In Recovery).  I right clicked on the database node in Management Studio and did a refresh and the status displayed correctly.

-Charlie

Answer 11

Louis answered it, as I see, but I knew of another recent blog post on this same topic, so I post it here

How much longer will the SQL Server database restore take

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 12

Thanks!! This work great!!! :) I just need to refresh the database.

Answer 13

Hi Guys,

I had less Space in Drive where Log (.ldf) File Exists. To release the Space I tried to Srink the Log File & release few space but Still I need more Free space so thought to Re-start the Server. When Re-started Server My one of the DB is in Recovery State. It is showing infront of DB Tartget (In Recovery).

What caused this? Even I noticed SQL Server Agent is Showing Error (Agent XPs disabled)

I followed below link but still same message it is displaying:

http://www.mssqltips.com/sqlservertip/2729/how-to-start-sql-server-agent-when-agent-xps-show-disabled/

---

Thanks Shiven:) If Answer is Helpful, Please Vote