sql数据库自动备份

 

declare @dbname varchar(500),@del varchar(500)

begin

set @dbname='"D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\ACS\ACS_AutoBackup_db_'+convert(varchar(10),(replace(convert(varchar(10),DATEADD(day, -3, getdate()),120),'-','')))+'.bak"'

--select @dbname

set @del='del '+@dbname 

--select @del

exec master.dbo.xp_cmdshell  @del

end