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