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…
- Make sure you have the correct path specified and that it does not have a “\” on the end
- 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.
