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