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

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
  • 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Router assigned IP addresses 18 98
Whats wrong in this query - Select * from tableA,tableA 11 45
Cisco EIGRP Network 6 20
Problem Description:   Couple of months ago we upgraded the ADSL line at our branch office from Home to Business line. The purpose of transforming the service to have static public IP’s. We were in need for public IP’s to publish our web resour…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), 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 (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), 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…

808 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