SQLSERVERデータベースのバックアップ/リカバリ、SQL一歩の実装

 --  SQL SERVER   

 BACKUP DATABASE book09 TO DISK ='c:\abc.bak' WITH init



--  SQL SERVER   
USE MASTER 
    --    ,             
    DECLARE @count int=0
    SELECT @count=COUNT(spid) FROM master..sysprocesses where dbid=db_id('book09')
    WHILE (CONVERT(int,@count)>0)
    BEGIN 
        DECLARE @j int=0;
        SELECT TOP 1 @j=spid FROM master..sysprocesses where dbid=db_id('book09');
        IF(@j<>0)  EXEC('kill '+@j)
         
        SELECT @count=COUNT(spid) FROM master..sysprocesses where dbid=db_id('book09')
    END
--       
RESTORE DATABASE book09 FROM DISK='c:\abc.bak' WITH REPLACE  

 
 

--select spid from master..sysprocesses where dbid=db_id('book09')
--KILL 56    
--exec sp_who