SQL Server - In Recovery
first you must identify the spid

look up 

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




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