CODEWITHSUNDEEP
sqlsql-serversql-server-2008t-sql
Lloyd Banks
Lloyd Banks

Reputation: 36679

Can't Kill SPID "Transaction Rollback in Progress"

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?

Upvotes: 8

Views: 13226

Answers (2)

Lloyd Banks
Lloyd Banks

Reputation: 36679

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

Upvotes: 2

András Ottó
András Ottó

Reputation: 7695

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

Upvotes: 3

Related Questions