I have a maintenance plan setup for all my user databases on a particular server, which does all the usually things at various intervals.
The 7th and final subplan is a two stage cleanup plan; firstly old full backups are deleted, then old transaction log backups are deleted. These tasks appear to run successfully - the subplan's job history reports that the plan was run on time, and runs xp_delete_file twice - but clearly files are not deleted.
The task settings are:
- Backup Files
- Search folder and delete based on extension - .bak
- Include subfolders
- Delete files older than 2 weeks
and
- Backup Files
- Search folder and delete based on extension - .trn
- Include subfolders
- Delete files older than 5 days
Any ideas?