The following BizTalk database jobs require additional configuration by your database administrator. It is critical for the health of the BizTalk application that these jobs are configured and that BizTalk database backups are performed using the jobs below.
-
Configure the Backup BizTalk Server job by modifying the paths configured:
BackupFull: exec [dbo].[sp_BackupAllFull_Schedule] 'd' /* Frequency */, 'BTS' /* Name */, '<backup directory>' /* location of backup files */
MarkAndBackupLog: exec [dbo].[sp_MarkAll] 'BTS' /* Log mark name */, '<backup directory>' /* location of backup files */
Note:This job runs every 15 minutes by default, and this schedule should not be modified.
-
Enable the DTA Purge and Archive job and schedule it to occur every 1 minute.
You must also create a method to remove the backup files created. This is typically done using another SQL Agent job. You can find more information on backing up and restoring a BizTalk Server at http://msdn.microsoft.com/en-us/library/aa562140.aspx.
You should not modify the default schedule of these SQL Agent jobs.
Do not run re-index or other types of maintenance jobs on these databases. Doing so could corrupt the data.
If your existing SQL Server instance is configured for database mirroring, a separate database server must be configured for BizTalk.