SQL Server 2008 - maint plan cleanup task not deleting old backup files
I have created a maintenance plan with only 1 task -- a cleanup task to delete all .bak files in the backup folder older than 1 week. The job completes successfully and the log file entry says it ran successfully but it's not deleting the old files. I have verified I have the file extension (.bak) and the backup folder correct. There are .bak files in that folder much older than 1 week but they do not get deleted. I checked the box that indicates to go 1 sub-folder below the one specified. At my last job I setup the maint plan this way and it worked fine.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.