問題描述
我的數據庫中有一條處于永久回滾模式的未提交語句.當我嘗試終止與此語句關聯的 SPID 時，出現以下錯誤:
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:
事務回滾正在進行中.預計回滾完成:0%.預計剩余時間:0 秒.
transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.
這條未提交的語句導致用戶無法查看數據庫的表、視圖和過程樹.如何停止此 SPID?
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?
推薦答案
未提交的事務是數據庫備份.有一個已知的錯誤(與 MS 修補程序一起)，備份有時會掛起.重啟集群解決了問題
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
這篇關于無法殺死 SPID“正在進行的事務回滾"的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！