SQL Server - In Recovery
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 In Recovery 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 can check for?

SQL Server - In Recovery
===

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 In Recovery 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 can check for?
