SQL Maintenance Plan Doesn't Delete Backups

Bradley Schacht

Bradley Schacht is a Cloud Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Administration". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as SQLServerCentral.com and an active member of the Jacksonville SQL Server User Group (JSSUG).

You may also like...

18 Responses

  1. Andy says:

    haha! Nice one, thanks for sharing. I was banging my head trying to see what was wrong.

  2. Bill says:

    Here is another caveat on the backup maintenance plan I discovered. My backups would not delete and I did not have .bak in the file extension but I did have BAK in the file extension. Once I changed this to all lowercase, it worked like a charm.

  3. Don says:

    Thanks for that great hint

  4. Mark S says:

    Thank you Bradley. Super tip !

  5. sugianto says:

    i have the same problem, everything look OK, task done, log success, but not delete anything,
    your sharing fix my problem, thanks for sharing

  6. Andrew says:

    Thanks! This solved my problem.

  7. Harry says:

    Nice Bradley – now how do we get MS to put this piece of crucial information in their documentation?

  8. JR says:

    I’m having the same issue with backups not being deleted, however I am not using .bak. I’m using bak as required and old backups still do not delete. A check of the logs shows the clean up task ran without error, yet is still not deleting the old files.

  9. Steve Lee says:

    OMG!!! Thanks a ton. I have been banging my head over this for months. All because I had the “.” in there.

  10. Dave says:

    Many thanks for this, had the very same problem. Thank you for sharing 😉

  11. Kent says:

    It’s hard to believe, that this is still tripping us all up. Thanks again for sharing

  12. Tim says:

    Thank you so much! Appreciate you sharing this. Was a big help.

  13. muctarrs says:

    Awesome ..thanks.Worked a treat!

  14. J C says:

    do wildcards work in the filename?

  15. bilzin says:

    Thanks alot! its working perfectly now.

  16. Melanie says:

    It is almost unbelievable to me that this is still an issue all these years later, but your post just saved my brain from exploding. Thanks so much!

  17. Gunnar says:

    Thank you, saved my day!

Leave a Reply