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

Create a successfull maintenance plan to delete old backups

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
valuelabs97
Asked:
valuelabs97
  • 2
  • 2
1 Solution
 
grayeCommented:
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
 
BioTechManicCommented:
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
 
grayeCommented:
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
 
BioTechManicCommented:
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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now