January 22, 2002 at 9:11 am
I have a SQL 2000 Maintenance plan which performs a full backup on a weekly basis. I noticed that whomever set it up did not have it delete old backups, which caused the backup drives to start filling up. I edited the plan to only keep the last two weeks (since I was backing up to tape also) but the plan does not delete the old backups. Looking at the maintenance plan log there are no entries of it even checking for old backups. Do maintenance plans generate a script at the time they are created and then not update the script, or am I hitting a bug in SQL2000?
Eugene
January 22, 2002 at 9:22 am
I use EM 2000 all the time and delete old backups after a few days - there is a check off box in the Complete DB and Tran Log backup tabs. Just check it off then enter the time you want the sys to start deleteing old backups. I have never had any problems!
Hope this helps
karen
January 22, 2002 at 9:25 am
Thats where my problem lies, I have checked the delete box and set it for 2 weeks. I still have plenty of backups older than two weeks that were not being deleted. I manually deleted them, but each time the job runs it creats new backups and leaves the old ones around.
January 22, 2002 at 10:37 am
Did you check the rights for the SQLAgnet? Log in as this user and see if you can delete the files. Also check the logs for the maintenance plans.
Steve Jones
January 23, 2002 at 11:03 am
I found it, someone else created another maint plan so I was looking at the log. It looks like it is looking at the old backups just not deleteing anything. Does the two week period start counting after the last current backup, so I have current, then week-1, then week-2?
Eugene
January 23, 2002 at 11:10 am
Im pretty sure it looks at last back up then deltes anything 2 weeks older
karen
January 23, 2002 at 11:14 am
January 23, 2002 at 11:25 am
So I should ahve three weekly backup files for a two week age limit then. It would appear to be delete older than 2 weeks but not equal to 2 weeks old (which is what I was assuming). I am planning on waiting untill the next weekly backup to see if it creates another or deletes the older one then I should know for sure.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply