MSSQL Maintenance cleanup task does not delete older files

If you are running Microsoft SQL Server 2008 R2 and find that your maintenance cleanup task is not deleting old files then it’s likely to be one of the following…

  1. Make sure you have the correct path specified and that it does not have a “\” on the end
  2. Make sure the file extension does not have a dot before it e.g.  “.bak” It should just read “bak”. You could also try *.* that would delete all files regardless of their file extension.



Leave a Reply