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

Delete old backup files

I have full backup and transaction log backup on a database, the full backup runs once a day and the transaction log backups run every hour. The issue that I am having is that although I have the backups expire after 2 days the old backup files are not being deleted automatically and after few days I run out od space and the backup fails. What am I doing wrong?

SQL server 2008
1 Solution
Ephraim WangoyaCommented:
You can add Maintenance task item to your Maintenance Plan and select to delete files older than the required criteria
What do you mean by backup expires? how you are doing that?
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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