Solved

Create a successfull maintenance plan to delete old backups

Posted on 2008-10-30
4
464 Views
Last Modified: 2012-08-14
Hi.

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.

Thanks
0
Comment
Question by:valuelabs97
  • 2
  • 2
4 Comments
 
LVL 41

Accepted Solution

by:
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
0
 

Expert Comment

by:BioTechManic
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.
0
 
LVL 41

Expert Comment

by:graye
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
0
 

Expert Comment

by:BioTechManic
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.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now