How to clean up all of the backupfiles created with the BizTalk Backup Job

As anyone who has fully implemented BizTalk will know, if you do not backup your databases you will have problems.

I can not stress more highly, please back up your BiTalk databases.

The next thing you will notice is that its not that simple, there is a Backup Job that ships with the product, that creates backups, you NEED to use this job to create your backups or you will not be supported.

The job will create a full backup daily, and a transactional log backup every 15 minutes. (This is configurable)

At the end of the day, you end up with quite a lot of files, that take up quite a lot of disk space depending on how active your solution has been.

In reality you should be archiving these backups daily, and cleaning up the backup directory. But what if your backup directory is on the SAN and its backuped up, but there are several days worth of backup still lying around

This happens more often than you would think, so we have 100’s of these backup files filling up the disk, which gets critical when the disk fills up.

So how do I clean up these files automatically…….