sqlserver实例无法加锁或者多于一个的连接时处理方法

问题：

use master; go alter database qcvalues set single_user with rollback immediate; set multi_user; go

I am getting these errors:

Msg 5061, Level 16, State 1, Line 1 ALTER DATABASE failed because a lock could not be placed on database 'qcvalues'. Try again later. Msg 5069,139)">DATABASE statement failed. Msg 4 DATABASE statement failed.

解决方案：

After you get the error,run

EXEC sp_who2

Look for the database in the list. It's possible that a connection was not terminated. If you find any connections to the database,139)">KILL <SPID>

where?<SPID>?is the SPID for the sessions that are connected to the database.

Try your script after all connections to the database are removed.

Unfortunately,I don't have a reason why you're seeing the problem,but here is a link that shows that the problem has occurred elsewhere.

http://www.geakeit.co.uk/2010/12/11/sql-take-offline-fails-alter-database-failed-because-a-lock-could-not-error-5061/

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!