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?
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...
|||Thanks Louis! It worked fine and the database eventually did recover.
|||Thanks Louis, it works for me too..
No comments:
Post a Comment