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:
我在数据库中以perptual rollback模式有一个未提交的语句。当我尝试杀死与此语句关联的SPID时，我收到以下错误：
transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.
正在进行事务回滚。预计回滚完成率：0％。预计剩余时间：0秒。
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?
此未提交的语句导致用户无法查看数据库的表，视图和过程树。如何停止此SPID？
2 个解决方案
#1
3
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论坛链接
#2
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
未提交的事务是数据库备份。有一个已知的错误（以及MS Hotfix）备份有时会挂起。重新启动群集修复了该问题
#1
3
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论坛链接
#2
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
未提交的事务是数据库备份。有一个已知的错误（以及MS Hotfix）备份有时会挂起。重新启动群集修复了该问题