February 2

MSSQL: Maintenance plan is not deleting the backup files

There are a few reasons that this task may fail, but one of the most common is the follow:
In Maintenance Cleanup Tasks, check to make certain the file extension entered is bak and not .bak.
Save your change and then test it.
It is normal to put a “.” then the file type in most search type functions, but the “.” in MSSQL will make it so nothing is deleted.

 


Copyright 2021. All rights reserved.

Posted February 2, 2015 by Timothy Conrad in category "Databases

About the Author

If I were to describe myself with one word it would be, creative. I am interested in almost everything which keeps me rather busy. Here you will find some of my technical musings. Securely email me using - PGP: 4CB8 91EB 0C0A A530 3BE9 6D76 B076 96F1 6135 0A1B