Configure the DTA Purge and Archive Job

How to Configure the DTA Purge and Archive Job

This topic has not yet been rated - Rate this topic

Before you can archive or purge data from the BizTalk Tracking (BizTalkDTADb) database, you must configure the DTA Purge and Archive (BizTalkDTADb) job. This job is configured to call the stored procedure dtasp_BackupAndPurgeTrackingDatabase, which uses the six parameters you must configure in this job.

Prerequisites

---

You must be logged on with an account that is a member of the SQL Server sysadmin fixed server role to perform this procedure.

To configure the DTA purge and archive job (SQL Server 2005)

---

1. On the SQL Server that hosts the BizTalk Tracking (BizTalkDTADb) database, click Start, click Programs, click Microsoft SQL Server 2005, and then clickSQL Server Management Studio.
2. In the Connect to Server dialog box, specify the name of the SQL server where the BizTalk Tracking (BizTalkDTADb) database resides and the appropriate authentication type, and then click Connect to connect to the appropriate SQL server.
3. In Microsoft SQL Server Management Studio, double-click SQL Server Agent, and then click Jobs.
4. In the details pane, right-click DTA Purge and Archive (BizTalkDTADb), and then click Properties.
5. In the Job Properties - DTA Purge and Archive (BizTalkDTADb) dialog box, under Select a page, click Steps.
6. In the Job step list, click Archive and Purge, and then click Edit.
7. On the General page, in the Command box, edit the following parameters as appropriate, and then click OK.
   
   • @nLiveHours tinyint — Any completed instance older than the (live hours) + (live days) will be deleted along with all associated data. Default is 0 hours.
     
   • @nLiveDays tinyint — Any completed instance older than the (live hours) + (live days) will be deleted along with all associated data. Default interval is 1 day.
     
     

     Note
     For the purposes of the BizTalk Tracking (BizTalkDTADb) database, the sum of LiveHours plus LiveDays is the live window of data you want to maintain in your BizTalk Server environment. All data associated with a completed instance older than the live window of data is deleted.
   • @nHardDeleteDays tinyint — All data (even if incomplete) older than this will be deleted. The time interval specified for HardDeleteDays should be greater than the live window of data. The live window of data is the interval of time for which you want to maintain tracking data in the BizTalk Tracking (BizTalkDTADb) database. Anything older than this interval is eligible to be archived at the next archive and then purged. Default is 30 days.
     
   • @nvcFolder nvarchar(1024) — Folder in which to put the backup files.
     
   • @nvcValidatingServer sysname — Server on which validation will be done. NULL value indicates no validation is being done. Default is NULL.
     
   • @fForceBackup int — Default is 0. This is reserved for future use.
     
   The edited command should look similar to this:
   
   exec dtasp_BackupAndPurgeTrackingDatabase 1, 0, 1, '\\MyBizTalkServer\backup', null, 0
   

8. On the Job Properties - DTA Purge and Archive (BizTalkDTADb) dialog box, under Select a page, click General, select the Enabled check box, and then click OK.