Checklist: Archiving and Purging the BizTalk Tracking Database
| Step | Reference |
|---|---|
|
Read the Archiving and Purging overview to become more familiar with the process of archiving and purging tracking data. |
|
|
Although you can run the DTA Purge and Archive job using your logon credentials, for added security, you should configure the BTS_BACKUP_USERS role with the necessary SQL Server credentials to run the DTA Purge and Archive job. This helps to prevent elevation of privileges. |
|
|
Configure the DTA Purge and Archive job. |
|
|
Run the DTA Purge and Archive job, which archives the data in your BizTalk Tracking (BizTalkDTADb) database and purges old data. |
|
|
Optionally, you can manually purge data from the BizTalk Tracking (BizTalkDTADb) database. |
How to Manually Purge Data from the BizTalk Tracking Database |
|
Enable automatic validation of the archived data from the BizTalk Tracking (BizTalkDTADb) database. |
|
|
Copy tracked messages into the BizTalk Tracking (BizTalkDTADb) database. This is required in order to purge data using the DTA Purge and Archive job. |
How to Copy Tracked Messages into the BizTalk Tracking Database |