BizTalk Bloggin'

Configuring BizTalk's SQL Server Agent Jobs

Backup BizTalk Server (BizTalkMgmtDb)

Edit step  2.

exec [dbo].[sp_BackupAllFull_Schedule] 'd' /* Frequency */
, 'BTS' /* Name */
, 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup' /* location of backup files */


Edit step 3.

exec [dbo].[sp_MarkAll] 'BTS' /* Log mark name */
, 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup' /* location of backup files */

DTA Purge and Archive (BizTalkDTADb)

Edit Step 2.


exec dtasp_BackupAndPurgeTrackingDatabase 0 --@nLiveHours tinyint
,1 --@nLiveDays tinyint = 0, --will be deleted along with all associated data
,30 --@nHardDeleteDays tinyint = 0, --all data older than this will be deleted.
,'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup' --backup folder
,null --@nvcValidatingServer sysname = null,
,0 --@fForceBackup int = 0

MessageBox_Message_Cleanup_BizTalkMsgBoxDb

Leave disabled