Create a successfull maintenance plan to delete old backups

Posted on 2008-10-30
Last Modified: 2012-08-14

I'm new to MS SQL 2005 and would like to create a maintenance plan to delete old backup files. Please assist me wit the steps.

Question by:valuelabs97
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 41

Accepted Solution

graye earned 125 total points
ID: 22840455
It's fairly straight forward...  you'd just create a new Maintenance Plan, drag the "Maintenance Cleanup" task item onto the plan, fill in the parameters you want (the backup directory, extension, and retention time).   Then schedule the task to run daily/weekly/whatever
...that's it... you're done

Expert Comment

ID: 34703300
I did that - and it does not work....the files are still there over one week old....

I setup Maintenance plan to clean up backup files from SQL 2005 server, but I found out every time I run the job (maintenance plan)- whether automatic or manual, the .bak files are still in the folders.  Any help or suggestion will be greatly appreciated?

P.S. I set it up to delete all files older than 1 week.
LVL 41

Expert Comment

ID: 34704495
I can only assume that you've put the backups in a place that's different from where the Maint Plan is looking.

... double check the paths

Expert Comment

ID: 34704520
no - they are pointing to the correct location.....but someone just shared with me that the file extension needs to only say "bak" and nothing else, no ".bak" no "*.bak" etx..... I had *.bak so I am going to test that and see what happens....thanks for responding btw.

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Linksys e2500 wireless router - should I upgrade 6 83
snmp-server enable traps gdoi ks-rekey-pushed 3 38
Where is running-config located at in ASR9K? 3 36
Configure BGP 22 54
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
After creating this article (, I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
After creating this article (, I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question