I'd like to create a set of backups for a SQL 2008 database. In one folder I want to have the last 7 days of daily backups, and in another folder I'd like to do the last 8 weeks of weekly backups.
I can create the backups fine, and using a date variable give them unique file names. What I'm not sure how to do is to set it up to delete the old ones so that only the last 7 days/8 weeks of files are kept.