i have created a Maintenance Plan for daily FULL Backup of 2 databases in a SQL Instance. The Job is taking backup file successfully but not cleaning up the old files. So my Disk is getting filled up with old backup files.
I have included 'Maintenance Cleanup task' in the Plan and the retention period to 2 days. Meaning we do not need any backup files prior to 2 days. Not sure why this is not able to clear the old backup copies.
The intresting thing is, I created a similar Plan on various SQL Instances and but selected default all databases option in the 'Backup Database task'. And it works like a charm.
Can you please suggest what is missing here. and please let me know if you need any information to figure out the bottle neck.