Can't see progress of rolling back SPID with KILL WITH STATUSONLY

Posted by BradC on Server Fault See other posts from Server Fault or by BradC
Published on 2009-08-25T17:56:15Z Indexed on 2012/12/19 17:04 UTC
Read the original article Hit count: 236

Filed under:
|
|

I have a SPID on SQL 2005 that shows in Activity Monitor as "ROLLBACK" mode (because a transaction log filled up, not because it was manually killed). I tried to see how much time it has left to roll back with a

KILL 115 WITH STATUSONLY

but it just said "Status report cannot be obtained. Rollback operation for Process ID 115 is not in progress."

Can I safely issue a "KILL 115" so that I can see the rollback status? Does this actually do anything on a spid currently in rollback?

© Server Fault or respective owner

Related posts about sql-server

Related posts about DBA