Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-08 : 15:42:05
|
pete writes "Please help! I am backing up to disk.
I want my schedule job to delete the most recent backup to reclaim the disk space BEFORE backing up my database using xp_maint(EM Maintenance Plan). Is there a way thru EM Plan?
Here's the scripts EM Maintenance Plan generated that I specify to delete backups older than 4 hours. It works, but this only deletes after completed the most recent backup. I want to delete before not after.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 5B5D29A8-ED64-11D4-B80E-00508BF91541 -Rpt "G:\MSSQL7\BACKUP\HRTRAIN daily backup4.txt" -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "G:\MSSQL7\BACKUP" -DelBkUps 4HOURS -BkExt "BAK"'" |
|
|
|
|
|
Delete Most Recent Backup Using EM Maintenance Plan