Configuring the BizTalk SQL Agent Jobs
March 2, 2013 3 Comments
One of the things people often forget to do when installing BizTalk into an environment for the first time is to configure and enable two critical SQL Server Agent jobs:
- Backup BizTalk Server
- DTA Purge and Archive
These jobs are not enabled by default because they both require you to supply UNC paths to the backup and archive file locations, respectively. While backups and archiving may not seem like the most immediate priority (especially in non-production environments), it is nonetheless essential that these jobs run successfully as they keep the BizTalk databases “lean & mean” by purging old data. I’ve seen client tracking databases grow to over 200GB in size when the latter job is not running properly (the Microsoft recommended size is <5GB!!)