SqlServer 备份与还原。

首先创建存储过程，执行下面的代码，

--杀掉进程

然后调用语句 exec killspid ? 加入到上面的SQL 语句里面即可

create???? proc???? killspid???? (@dbname???? varchar(20))????

as????

begin????

declare???? @sql???? nvarchar(500)????

declare???? @spid???? int????

set???? @sql= 'declare???? getspid???? cursor???? for????????

select???? spid???? from???? master.dbo.sysprocesses???? where???? dbid=db_id( '''+@dbname+ ''')'????

exec???? (@sql)????

open???? getspid????

fetch???? next???? from???? getspid???? into???? @spid? ???

while???? @@fetch_status???? <???? > -1????

begin????

exec( 'kill???? '+@spid)????

fetch???? next???? from???? getspid???? into???? @spid????

end????

close???? getspid????

deallocate???? getspid????

end?

use master

go

--脱机

alter database demo set offline

?

?

use master

go

--连机

alter database demo set online

（编辑：李大同）

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