I'm doing a full backup of the database every night and a backup of the logfiles every 15 minutes via a maintenance plan. Full backups are removed after 5 days, transaction backups after 1 day. I think a better solution should be that the transaction log backups are only deleted after a successful full backup. When a full backup fails I want to keep my transaction log backups until the next successful full backup. How can I automate this? Thanks in advance.