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.

MSDN forum link

Share:
11,931
Lloyd Banks
Author by

Lloyd Banks

Updated on June 19, 2022

Comments

  • Lloyd Banks
    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?