Maintenance Plan Clean up task not deleting all .bak files

  • Hi,

    I have a maintenance plan that backs up my databases and deletes any .bak files older than 2 days old. I am running this on 2008 R2 and it sometimes work fine. Other times it randomly leaves behind a few (between 2-5) of the 9 databases being backed up. It doesn't leave behind specific ones it just seems random.

    Does anyone know any known bugs or problems like this?

    Thanks for any help.

  • If you have .bak as the in the file extension field, change it to only bak without any dots/asterisks and try again.

  • Hi,

    I do not have the . before the bak sorry, that was just to explain what type of file they were. I have encountered that problem before and learnt from it! It does delete some backs up but not all.

  • You could try a couple of other things like:

    1. Have a look at your maintenace plan, click edit on the subplan and click on view t-sql. Any problems there?

    2. Delete your maintenance plan and just create a new one, this has worked for my on a couple of occasions.

    3. Create a new maintenance plan that does what your original plan, point it to another folder and test it for one

    small database.

    Is your instance RTM version? Maybe there is a SP or CU that will solve this, always seems to be some problems with

    maintenance plans and early versions of SQL Server.

    I would recommend you to have a look at Ola Hallengrens maintenance solution http://ola.hallengren.com.

    It is a great solution for backups and mainteance that has made my life much easier. Spend a couple of hours testing

    it and I assure you that you will start using it instead of the built in maintenance plans.

  • raadee (8/5/2013)


    I would recommend you to have a look at Ola Hallengrens maintenance solution http://ola.hallengren.com.

    It is a great solution for backups and mainteance that has made my life much easier. Spend a couple of hours testing

    it and I assure you that you will start using it instead of the built in maintenance plans.

    I would second this - Once you learn Ola's framework, the built in maintenance plans will make your skin crawl.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply