复制declare @data_ago nvarchar(50) declare @cmd varchar(50) set @data_ago =D:\bak\+backupname+convert(char(8),中使getdate()-15,112) +.bak set @cmd = del + @data_ago exec master..xp_cmdshell @cmd DECLARE @strPath NVARCHAR(200) set @strPath = D:\bak\ + backupname+ convert(char(8),getdate(),112) + .bak BACKUP DATABASE [databasename] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP 1.2.3.4.5.6.7.8.9.10. |
喜欢
讨厌