新增文章

文章标题分类内容

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

ALTER   DATABASE  K3151_2023 SET SINGLE_USER WITH ROLLBACK IMMEDIATE ;

RESTORE DATABASE  K3151_2023 FROM  DISK = N'C:\Data\bak 2023\K3151_2023.bak'  WITH FILE = 1 ,NOUNLOAD ,REPLACE ,STATS = 5

,MOVE 'SCM102SP2_Data' TO 'C:\Data\mdf\K3151_2023_Data.mdf'
           ,MOVE 'SCM102SP2_log'  TO 'C:\Data\mdf\K3151_2023_Log.ldf'  
     ;

ALTER   DATABASE  K3151_2023 SET MULTI_USER ;

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

declare @dbName varchar(100)  select @dbName = 'K3151_2023'        -- 要还原的 数据库名称
   
   declare @path   varchar(100)  select @path   = 'C:\Data\bak 2023'  -- 备份文件位置
   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 ''SCM102SP2_Data'' TO '''+ @path2 +'\'+ @dbName +'_Data.mdf''
           ,MOVE ''SCM102SP2_log''  TO '''+ @path2 +'\'+ @dbName +'_Log.ldf''  
     ;

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

print @sql  ; 
   exec( @sql );