How to remove database backups 2 days or older through SQL Server 2005 Integration Service?

Question

I have a simple Integration Service package which has one SQL Task as shown below;

• WLSTAGE Bakup using Red Gate: Calls master..sqlbackup to backup database

Here is the SQL to run the actual backup

exec master..sqlbackup '-E -SQL "BACKUP DATABASE [WLSTAGE] TO DISK = ''\\Backups\<AUTO>'' WITH COMPRESSION = 1, INIT, MAILTO = ''<left blank intentionally>'', VERIFY"'

Since I have specified the backup file name as <AUTO>, I am wondering if there is a simple way to remove backups older than 2 days (if possible, without having to write any plumbing code to parse the file name).

Answer 1

I'm not sure what the AUTO statement does, but you are probably aware of the Maintenance Cleanup task. Does it not do what you need?

I like powershell for things like this as well.

(get-item -path "d:\perflogs\*" | where {$_.creationTime -lt ((get-date) - (new-timespan -days 30))} | where {$_.extension -eq ".blg"}) | remove-item