Can't Kill SPID "Transaction Rollback in Progress"
11,931
Solution 1
The uncommitted transaction was a database backup. There is a known bug (along with MS Hotfix) where the backup sometimes hangs up. Restarting the cluster fixed the issue
Solution 2
I found this thread, it seems, if it is started you can't kill it with command. Only if you are making your db offline.
Author by
Lloyd Banks
Updated on June 19, 2022Comments
-
Lloyd Banks almost 2 years
I have an uncommitted statement in perptual rollback mode in my database. When I try to kill the SPID associated with this statement, I get the following error:
transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.
This uncommitted statement is causing users to not be able to view the DB's table, view, and procedure trees. How do I stop this SPID?