Maint Plan: automatic removal of backup file 
Author Message
 Maint Plan: automatic removal of backup file

In a maintenance plan, can specify how many days to keep
backup files for a database backup.  Backup files older
than that number of days are deleted.  A couple of times
of the past 2 years this automatic deletion function has
seemingly turned itself off.  The only way I could remedy
this was to make some change to the maintenance plan and
re-save.  Then the automatic deletion would work again.

A week ago this happened and I re-saved the maintenance
plan which remedied the situation.  However, today I
noticed that of the 12 databases being backed up, only 9
had their "old" backup files automatically deleted.

This SQL Server is v7.0 with SP3 running on Win 2000.  

Any ideas on this?

Tue, 27 Sep 2005 15:53:51 GMT
 [ 1 post ] 

 Relevant Pages 

1. Removal Trans.logs backup files fails - (Backup Maintenance Plan)

2. Zipping Backup Files as part Maint. Plan

3. Backup Device vs Backup in Maint Plan

4. backup to tape using maint.plan - is it an append or overwrite

5. Backups using the Maint Plan

6. System DB maint plan skips backup of Master tlog

7. Differential backup MSSQL7 using Maint Plan

8. DB backup retention period in Maint Plan

9. db maint plan backup w/ devices

10. Maint plans and differential backup

11. Maint. Plan not deleting files

12. Automatic removal of sessions

Powered by phpBB® Forum Software