[Table] 備份維護計畫

USE [MSDB]

sysmaintplan_plans
sysmaintplan_subplans
sysmaintplan_log
sysmaintplan_databases



BACKUP DATABASE [OverTime] TO  DISK = N'E:\Backup\SQL\OverTime\OverTime_backup_201104150931.bak' WITH NOFORMAT, NOINIT,  NAME = N'OverTime_backup_20110415093118', SKIP, REWIND, NOUNLOAD,  STATS = 10

EXECUTE master.dbo.xp_delete_file 0,N'E:\Backup\SQL\OverTime',N'BAK',N'2011-04-01T09:33:19'