新增文章

文章标题分类内容

/*
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
   还原数据库  K3 Cloud 8.1 账套文件

ALTER   DATABASE  demo_test SET SINGLE_USER WITH ROLLBACK IMMEDIATE  
 
       RESTORE DATABASE  demo_test FROM  DISK = N'C:\Data\bak\demo_test.bak'  WITH FILE = 1 ,NOUNLOAD ,REPLACE ,STATS = 5

,MOVE 'SqlServer_BC_20120727194252_Data' TO 'C:\Data\mdf\demo_test_Data.mdf'
        ,MOVE 'SqlServer_BC_20120727194252_Log'  TO 'C:\Data\mdf\demo_test_Log.ldf'

ALTER   DATABASE  demo_test SET MULTI_USER

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
   use master

declare @dbName varchar(100)  select @dbName = 'demo_test'        -- 要还原的 数据库名称
   declare @path   varchar(100)  select @path   = 'C:\Data\bak'      -- 备份文件位置
   declare @path2  varchar(100)  select @path2  = 'C:\Data\mdf'      -- 数据文件位置
   
   declare @filePath varchar(100)   select @filePath = @path +'\'+ @dbName +'.bak'     -- 备份文件名 C:\Data\bak\master.bak

declare @sql varchar(2000)

select @sql = '
    
    ALTER   DATABASE  '+ @dbName +' SET SINGLE_USER WITH ROLLBACK IMMEDIATE ;

RESTORE DATABASE  '+ @dbName +' FROM  DISK = N'''+ @filePath +'''  WITH FILE = 1 ,NOUNLOAD ,REPLACE ,STATS = 5

,MOVE ''SqlServer_BC_20120727194252_Data'' TO '''+ @path2 +'\'+ @dbName +'_Data.mdf''
           ,MOVE ''SqlServer_BC_20120727194252_Log''  TO '''+ @path2 +'\'+ @dbName +'_Log.ldf''  
     ;

ALTER   DATABASE  '+ @dbName +' SET MULTI_USER ;
   ';

print @sql ; 
     exec( @sql );