Sql-server – SQL Server – In Recovery

sql serversql-server-2008

Was uploading a few hundred thousand rows in my SQL 2008 R1 database and have come in this morning to an "In Recovery" message next to the database name in SQL Management Studio.

I've tried a DBCC CheckDB, which returns CHECKDB found 0 allocation errors and 0 consistency errors in database 'DBName'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator. When I check the status (state_desc) in sys.databases, it returns ONLINE. In fact, nothing in the sys.databases table looks out of the ordinary.

I can't get rid of the 'In recovery' message though, and I don't want to just restart. Is there any way of telling how long it will be like this for, or are there any other problems I should check for?

Best Answer

first you must identify the spid

look up

sp_who2 'active' ---> look for the spesific session_id

enter image description here

SELECT * FROM sys.dm_exec_sessions WHERE session_id = 60 SELECT command,percent_complete FROM sys.dm_exec_requests WHERE session_id = 60

enter image description here

Related Question