HanShi, the table [sysmaintplan_logdetail] is what I need. Like you said I can derive the backups taken by the scheduled task IDs.

I had no idea that this table existed. It's...

Hi HanShi, thanks for your reply but I don't think that gives me the link to which Maintenance plan step created a backup.

I'll give you an example. If...

I would not like to change the backup file names with a prefix name of the maintenance sub-plan. I want to maintain the default file name generated by the...