数据库正在使用，恢复备份失败的解决办法

 

/* 
断开所有用户打开的连接 
*/ 
use master 
go 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_killspid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) 
drop procedure [dbo].[p_killspid] 
GO 

create proc p_killspid 
@dbname sysname --要关闭进程的数据库名 
as 
declare @s nvarchar(1000) 
declare tb cursor local for 
select s='kill '+cast(spid as varchar) 
from master..sysprocesses 
where dbid=db_id(@dbname) 

open tb 
fetch next from tb into @s 
while @@fetch_status=0 
begin 
exec(@s) 
fetch next from tb into @s 
end 
close tb 
deallocate tb 
go 

--用法 
exec p_killspid 'hj' 

 

来自：http://www.cnblogs.com/xy6521/articles/1364065.html

个人学习收藏