Databases You Must Back Up

You use the Backup BizTalk Server job to back up all of these databases, except BAM Analysis and Tracking Analysis Server. To back up BAM Analysis and Tracking Analysis Server, you use SQL Analysis Manager.

For information about the Backup BizTalk Server job, see Scheduling Database Backups.

The following table lists the databases that you must back up on a regular basis.

DatabaseDefault database nameDescription
BAM Primary Import BAMPrimaryImportThis is the database where the Business Activity Monitoring tool collects the raw tracking data.
BAM Star Schema BAMStarSchemaThis database contains the staging table, and the measure and dimension tables.
BAM Analysis BAMAnalysisThis database contains Business Activity Monitoring OLAP cubes for both online and offline analysis.
BAM Archive BAMArchiveThis database archives old Business Activity data. Create a BAM Archive database to minimize the accumulation of Business Activity data in the BAM Primary Import database.
HWS Administration BizTalkHWSDbThis database contains all administration information related to Human Workflow Services (HWS).
BizTalk Tracking BizTalkDTADbThis database stores business and health monitoring data tracked by the BizTalk Server tracking engine.
BizTalk Configuration BizTalkMgmtDbThis database is the central meta-information store for all BizTalk Servers.
BizTalk Message Box BizTalkMsgBoxDbThis database stores subscription predicates. It is a host platform, where the queues and state tables for each BizTalk Server host are kept. This database also stores the messages and message properties.
Rule Engine BizTalkRuleEngineDbThis database is a repository for:
  • Policies, which are sets of related rules.
  • Vocabularies, which are collections of user-friendly, domain-specific names for data references in rules.
Credential SSODBThis Enterprise Single Sign-On credential database securely stores the configuration information for receive locations.
Trading Partner Management TPMThis database stores trading partner data for Business Activity Services (BAS).
Tracking Analysis Server BizTalkAnalysisdbThis database stores both business and health monitoring OLAP cubes.
BizTalk EDI BizTalkEDIdb This database stores state for the electronic data interchange (EDI) feature.

You must also back up the following Windows SharePoint Services databases, which are used by Business Activity Services (BAS):

  • Windows SharePoint Services configuration database
  • Windows SharePoint Services content database

See Also

About Database Backup and Recovery

To download updated BizTalk Server 2004 Help from, go to

Copyright © 2004 Microsoft Corporation.
All rights reserved.