Home / server / Questions / 94094
Accepted
CJM
Asked: 2009-12-15 02:58:26 +0800 CST

Maintenance Cleanup Task(s) running 'successfully' but not deleting back up files

  • 772

I have a maintenance plan setup for all my user databases on a particular server, which does all the usually things at various intervals.

The 7th and final subplan is a two stage cleanup plan; firstly old full backups are deleted, then old transaction log backups are deleted. These tasks appear to run successfully - the subplan's job history reports that the plan was run on time, and runs xp_delete_file twice - but clearly files are not deleted.

The task settings are:

  • Backup Files
  • Search folder and delete based on extension - .bak
  • Include subfolders
  • Delete files older than 2 weeks

and

  • Backup Files
  • Search folder and delete based on extension - .trn
  • Include subfolders
  • Delete files older than 5 days

Any ideas?

sql-server

1 Answers

  1. Best Answer

    And of course, as soon as I post I figure out the answer...

    There a number of people suffering similar problems (2005 as well) and solutions range from scripts to SPs and to hotfixes.

    Mine was much simpler - I'd specified '.BAK' as the extension, rather than 'BAK'!

    It's a bit of a 'Doh!' moments, but nevertheless, I'd have hoped that the GUI would have either handled the situation or at least complained to me about the problem.

    Anyway, problem solved...

    • 3