数据库自动备份、删除
备份:
需要将 DB_SCJC改成自己的数据库。
declare @filename varchar(255) set @filename ='C:\Pro\DB_SCJC_' + convert(varchar(50),getdate(),102) + '.bak' BACKUP DATABASE [DB_SCJC] TO DISK = @filename WITH NOFORMAT, NOINIT, NAME = N'DB_SCJC-完整数据库备份', SKIP, NOREWIND, NOUNLOAD, STATS = 1,compression
删除七天以外的数据库文件:
DECLARE @OLDDATE DATETIME SELECT @OLDDATE=GETDATE()-7 EXECUTE master.dbo.xp_delete_file 0,N'C:\Pro\',N'bak',@olddate