We came across several postings in Forums about Maintenaceplan cleanup task not deleting the backup files if backups of databases were created under separate folders. This helped us take immediate action to address it in our service pack(SP).

This issue is now addressed in Service Pack 1. The private beta of SP1 is released and public beta release of SP1 is expected to be sometime this month.

Thanks for all your feedback and we hear and value every feedback we get!

Gops Dwarak, Program Manager, SQL Server Tools Team, Microsoft

My particular backup problem is that when I do a full backup on some transaction-heavy databases that have their recovery models set to Full, the first hourly transaction log - .trn file - after the full backup is almost the same size as the .bak file. 

Subsequent hourly .trn files are nice and small.

I wanted all the .trn files to be small, to conserve drive space, so I tried setting the recovery models to bulk_logged, then do the .trn backup, then setting the recovery models back to Full, but this three-step approach seems to either take forever, or fail.

Any ideas would be appreciated.

 Thanks, Mike