Managing BAM Databases

Administrators use the BAM Management utility (bm.exe) to set up, manage, and update the BAM databases. This section shows you how to use the BAM Management utility to perform these common administrator tasks for the BAM databases, which are described in the following table.

For information about backing up and restoring the BAM databases, see Backing Up and Restoring BAM.

Database	Default database name	Description
BAM Primary Import database	BAMPrimaryImport	Where BAM collects raw tracking data.
BAM Notification Services Application database	BAMAlertsApplication	Contains alert information for BAM notifications. For example, when you create an alert using the BAM portal, entries are inserted in the database specifying the conditions and events to which the alert pertains, as well as other supporting data items for the alert.
BAM Notification Services Instance database	BAMAlertsNSMain	Contains instance information specifying how the notification services connect to the system that BAM is monitoring.
BAM Star Schema database	BAMStarSchema	Contains the staging table, and the measure and dimension tables.
BAM Analysis database	BAMAnalysis	Contains BAM OLAP cubes for both online and offline analysis.
BAM Archive database	BAMArchive	Archives old business activity data. You can create a BAM Archive database to minimize the accumulation of business activity data in the BAM Primary Import database.

In This Section

• Archiving Primary Import Database Data

• Creating a Partitioned View in the Archiving Database

• Scheduling SQL Server Integration Services Packages

• How to Set Up the BAM Databases Using the BAM Management Utility

• How to Retrieve the BAM Configuration File Using the BAM Management Utility

• How to Update the BAM Configuration Using the BAM Management Utility

• How to Reference Additional BAM Primary Import Databases

• How to Disable a BAM Primary Import Database Reference

• How to List All Referenced Databases

• How to Remove Incomplete Activity Instances

• How to Update the BAM Management Utility Configuration After a Backup and Restore

• How to Integrate BAM with SQL Server Reporting Services

See Also

Managing BAM