SQL 2005 Maintenance Cleanup Task fails to delete “.bak” files

2017-12-11T11:12:12+00:00 October 7th, 2011|SQL|

After creating a Maintenance Cleanup Task to delete old backup files with “.bak” specified as  the File Extension, you may come across an issue where the job completes without error but non of the backup files specified are deleted.

image

Solution

Specify the file extension as “bak” as the dot is not required

image