SQLServer 生成当前日期备份

DECLARE @DataBase NVARCHAR(64) 
 
 
 

   DECLARE @strDate NVARCHAR(64) 
 
 
 

   DECLARE @strPath NVARCHAR(512) 
 
 
 
 
  
 
 

   --备份采集配置数据库 
 
 
 

   use TestDB 
 
 
 

   SET @DataBase='TestDB' 
 
 
 

   set @strPath='E:\数据库备份\' 
 
 
 

   set @strDate = convert(NVARCHAR(19),getdate(),120) 
 
 
 

   set @strDate = REPLACE(@strDate, ':' , '') 
 
 
 

   set @strDate = REPLACE(@strDate, ' ' , '') 
 
 
 

   set @strDate = REPLACE(@strDate, '-' , '') 
 
 
 

   set @strPath = @strPath + @DataBase + '_' + @strDate + 'Auto.bak' 
 
 
 
 
  
 
 

   DUMP  TRANSACTION  TestDB WITH  NO_LOG     
 
 
 

   BACKUP LOG TestDB WITH NO_LOG 
 
 
 

   DBCC SHRINKFILE (TestDB_Log, 1); 
 
 
 
 
  
 
 
 
  
 
 

   BACKUP DATABASE @DataBase TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT