Clean Up Maintenance Plans does not delete files if File age is specified
1. Create a maintenance plan with Clean Up Maintenance Plan task
2. Set up a file age option so that some files are going to be deleted
3. Save the plan and run.
Result: Expected files to delete are not removed
Expected Result: Out of date files should be deleted.
Software Defect
WORKAROUND:
Use the Maintenance Plan task "Cleanup TASK" instead, to remove old files.
CR 100651 created to address this issue.
This has been fixed in LiteSpeed version 7.1 and higher.
Cleanup Task (for files aged 1 day) generates t-sql similar to:
execute master.dbo.xp_slssqlmaint N'-MAINTDEL -DelDeviceType DISK -DELTYPE FileBkup -DELUSEAGE "1" -DELUNITTYPE "DAYS" -DELSUBFOLDERS -DELEXTENSION "bak" -DELFOLDER "C:\Backup\" '