• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 461
  • Last Modified:

SQL 2005 backup Maintenance Plans

a backup maintenance plan was created.  "Backup set will expire" was set to 2 days.  I assumed that meant SQL would delete the old backup files due to their expiring?  This is not occurring.  What is the process to get the old backups deleted?  I do not wish to have dozens of full backups.  I only want to have 2 sets of full backups.
2 Solutions
dastaubAuthor Commented:
I did notice the file names SQL gives the full backups and transaction log backups are given unique names by adding the date and time to the name of the backup file name.
Aneesh RetnakaranDatabase AdministratorCommented:
there is a task  "Cleanup backup files" , you can use that to delete the data older than 2 days.
Steve WalesSenior Database AdministratorCommented:
In SQL Server 2005 the task is actually called "Maintenance Cleanup Task".  You can add that as a step after your backup to clean up files older than "x" days.

You should also run the History Cleanup Task as well from time to time to clean up your backup history out of msdb.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now