脚本自动备份数据库

广告：

DECLARE @strPath NVARCHAR(200)
set @strPath = convert(NVARCHAR(19),getdate(),120)
set @strPath = REPLACE(@strPath, ':' , '.')
set @strPath = 'E:\HIS BACKUP\' + 'HealthOne_backup_'+@strPath + '.bak'
BACKUP DATABASE [HealthOne] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

DECLARE @strPath2 NVARCHAR(200)
DECLARE @strPathdel NVARCHAR(200)
set @strPath2 = convert(NVARCHAR(19),getdate()-8,120)
set @strPathdel = 'E:\HIS BACKUP\' + 'HealthOne_backup_'+@strPath2 + '.bak'
del @strPathdel

set @strPath2 = convert(NVARCHAR(19),getdate()-9,120)
set @strPathdel = 'E:\HIS BACKUP\' + 'HealthOne_backup_'+@strPath2 + '.bak'
del @strPathdel

广告：