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: 229
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