Msg 1205,Level 13,State 68,Line 1
Transaction (Process ID 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

尝试以下操作时收到该错误(使用主数据库作为系统管理员)：

ALTER DATABASE dbname
SET MULTI_USER;
GO

为了它,我尝试重新启动sql Server,我尝试杀死任何进程,我甚至尝试自己重置单个用户：

ALTER DATABASE dbname
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
GO

正在运行的作业旨在复制数据库并立即将其置于单用户模式以尝试使其更快.

无论如何我可以删除锁？