Configuring the BizTalk database jobs

BizTalk Server database jobs are required to keep BizTalk healthy. The jobs are important for preventing the database from becoming too large and cripple BizTalk's performance. The following table lists the BizTalk Server and SQL Server Agent jobs with a description of their responsibilities:

Job name


Backup BizTalk Server

It consists of several steps to perform full database backups of the BizTalk Server databases and logs. It also specifies a retention period of the backup history.


It deletes expired BizTalk Framework entries from the BizTalk Management (BizTalkMgmtDb) database.

DTA Purge and Archive

It automates the archiving of tracked messages ...

Get BizTalk Server 2010 Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.