还原数据库完整sq语句l

use master go

declare @dbname varchar ( 20) set @dbname = 'QADB' declare @sql nvarchar ( 500) declare @spid int --SPID 值是当用户进行连接时指派给该连接的一个唯一的整数 set @sql = 'declare getspid cursor for select spid from sysprocesses where dbid=db_id(''' + @dbname + ''')' exec ( @sql ) open getspid fetch next from getspid into @spid

while @@fetch_status <>- 1-- 如果 FETCH 语句没有执行失败或此行不在结果集中。

begin exec ( 'kill ' + @spid ) -- 终止正常连接 fetch next from getspid into @spid end close getspid

deallocate getspid go

restore database qadb from disk = 'D:SqlDataQADB_2017-05-09.bak'