DECLARE @dbname VARCHAR(20);  
SET @dbname = 'msdb';  
DECLARE @sql VARCHAR(500);  
DECLARE @spid INT;  
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 BEGIN  
    EXEC('KILL ' + @spid);  
    FETCH NEXT FROM GETSPID INTO @spid;  
END;  
CLOSE GETSPID;  
DEALLOCATE GETSPID;  


restore database msdb from disk = 'E:\馬克思主義\bwk_aslk\master&msdb\bwk_aslk_msdb.bak' with replace ,stats = 10