SQL Server自动备份、压缩和删除压缩

来源：互联网发布：布谷布谷软件编辑：程序博客网时间：2024/05/21 09:33

EXEC sp_configure 'show advanced options', 1;RECONFIGURE;EXEC sp_configure 'xp_cmdshell', 1;RECONFIGURE;declare @prefix         nvarchar(100),        @datefile       nvarchar(100),        @bakfile        nvarchar(100),        @rarfile        nvarchar(100),        @rarcmd         nvarchar(150),        @str_date       nvarchar(100),        @sql            nvarchar(100)        --设置备份的目录      set @prefix='D:/DataBase/' set @str_date = replace(replace(replace(convert(varchar(20),getdate(), 120),' ',''),'-',''),':','')set @datefile = 'xx' +@str_dateset @bakfile = @prefix+@datefile+'.bak'set @rarfile = @prefix+@datefile+'.rar'--备份BACKUP Database mpe_db_Data TO DISK = @bakfile WITH NOFORMAT, NOINIT,  NAME = N'xx-完整 数据库 备份', SKIP, NOREWIND, NOUNLOAD,  STATS = 10--压缩rarset @rarcmd ='"c:\Program Files\WinRAR\winrar.exe" ' +'a -df ' +@rarfile+' '+@bakfileexec master..xp_cmdshell @rarcmd,NO_OUTPUT;

--删除15天之前的备份set  @sql='del  d:\DataBase\xx' +rtrim(replace(replace(replace(convert(varchar(20),getdate()-15, 120),' ',''),'-',''),':',''))+'.rar'exec master..xp_cmdshell @sql,NO_OUTPUT;

0 0