SQL Server Backup

来源:转载

其中的全部的步骤是:
 
首先要编辑backup_YESHARE:
DECLARE @strPath NVARCHAR(200)
set @strPath = convert(NVARCHAR(19),getdate(),120)
set @strPath = REPLACE(@strPath, ':' , '-')
set @strPath = 'D:/DB_BACKUP_AUTO/YESHARE/' +'DB_Bak' [email protected] + '.bak'
BACKUP DATABASE YESHARE TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
 
删除旧有备份5day ago:
DECLARE @OLDDATE DATETIME
SELECT @OLDDATE = GETDATE()-5
EXECUTE master.dbo.xp_delete_file 0,N'D:/DB_BACKUP_AUTO/YESHARE/',N'BAK',@OLDDATE
 
在advanced标签中,设置为:
Go to the next step
 
另外一个为:
DECLARE @strPath NVARCHAR(200)
set @strPath = convert(NVARCHAR(19),getdate(),120)
set @strPath = REPLACE(@strPath, ':' , '-')
set @strPath = 'D:/DB_BACKUP_AUTO/IndustryTradeSystem/' +'DB_Bak' [email protected] + '.bak'
BACKUP DATABASE IndustryTradeSystem TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
 
最后一个执行完毕后选择:
quit the job reporting success
 
-----
以上命令搞定后u,需要设置什么时间执行这些命令:
在schedules标签中,




分享给朋友:
您可能感兴趣的文章:
随机阅读: