I have been having a problem with the maintenance plan where it does not remove transaction logs older than the specified number of days set in the properties. In one plan, i have 5 databases manually selected and i have enabled the transaction log backup once a week and the plan is supposed to remove the .trn files older than a week. However, only 2 databases are showing .trn files and those .trn files are never deleted, and just keep adding up week by week. Other plans are working fine. Do you have any idea what could be causing this? Do i need to limit one plan per db when backing up the transaction log?