Update References to the BAM Primary Import Database Name and Connection String

If you backed up your BAMPrimaryImport database in the event of a system or data failure, you can restore that backup to a different computer and rename the backup.

The BAM Event Bus service moves event data from the MessageBox database to the BAMPrimaryImport database. The BAM Event Bus service includes fault tolerance logic that enables it to recover and restart from an unexpected failure without losing any data. For more information about the BAM Event Bus service, see Managing the BAM Event Bus Service.

To restore the BAMPrimaryImport database, perform the steps in How to Restore Your Databases. In addition, you must perform these general steps, which are followed by a procedure that describes the steps in detail:

  • Update the SQL Connection 1 in all BAM DTS packages to refer to the new database name.

  • Update the web.config file with the new database name.

  • Update the reference to BAMPrimaryImport database in all BAM Livedata Microsoft Excel files.

Prerequisites

Sign in as a member of the BizTalk Server Administrators group.

Update the references

  1. Stop any BAM cube update and data maintenance Data Transformation Services (DTS) packages, or prevent them from running until you have restored the BAMPrimaryImport database.

  2. Stop the BizTalk Application service (which includes the BAM Event Bus service) so it does not try to import more data into the database.

    1. From the Start menu, type services.msc, and open Services.

    2. Right-click the BizTalk Service BizTalk Group: BizTalkServerApplication service, and then Stop.

  3. Restore the BAMPrimaryImport database (steps in How to Restore Your Databases).

  4. Update the following Web.Config files:

    • \Program Files\Microsoft BizTalk Server\BAMPortal\BamManagementService\Web.Config.

      Replace the <ServerName> string with the new server name, and <DatabaseName> with the new database name. Update the following connection strings:

      <appSettings>

      <add key="BamServer" value="<ServerName>" />

      <add key="BamDatabase" value="<DatabaseName>" />

      <add key="MaxResultRows" value="2000" />

      </appSettings>

    • \Program Files\Microsoft BizTalk Server\BAMPortal\BamQueryService\Web.Config.

      Replace the <ServerName> string with the new server name and <DatabaseName> with the new database name. Update the following connection strings:

      <appSettings>

      <add key="BamServer" value="<ServerName>" />

      <add key="BamDatabase" value="<DatabaseName>" />

      <add key="MaxResultRows" value="2000" />

      </appSettings>

  5. Open a command prompt (Start menu > Command Prompt), and navigate to the following directory: \Program Files\Microsoft BizTalk Server\Schema\Restore.

  6. Right-click SampleUpdateInfo.xml, and Edit.

    1. Comment out all of the database sections except for the OldPrimaryImportDatabase, PrimaryImportDatabase, ArchivingDatabase, AnalysisDatabase, StarSchemaDatabase, and Alert.

    2. For the OldPrimaryImportDatabase, PrimaryImportDatabase, ArchivingDatabase, AnalysisDatabase, StarSchemaDatabase, and Alert sections, set the SourceServer and Destination Server to the name of the existing server where those databases reside.

    3. For PrimaryImportDatabase, set the "SourceServer" to the name of the server where you have moved the BAM Primary Import database.

      Important

      Include the quotation marks around the name of the source and destination systems.

      Note

      If you renamed any of the BizTalk Server databases, be sure to also update the database names.

    4. When you are finished editing the file, save it, and exit.

  7. At the command prompt, type:

    cscript UpdateDatabase.vbs SampleUpdateInfo.xml

    Note

    Only run UpdateDatabase.vbs once.

    On 64-bit computers, run UpdateDatabase.vbs from a 64-bit command prompt.

  8. At the command prompt, navigate to the following directory:

    \Program Files\Microsoft BizTalk Server\Tracking

  9. At the command prompt, edit bm.exe.config, change the value of key="DefaultServer" to the new server name, and then save the file.

  10. Update the reference to BAMPrimaryImport database in all BAM Livedata Microsoft Excel files. For each file:

    1. Open the Excel live data file. The file name ends with _LiveData.xls.

    2. On the BAM menu, click BAM DB Connection.

    3. In the Select BAM Database dialog box, enter the SQL Server and BAMPrimaryImport database, and then click OK.

    4. On the File menu, click Close and Return to Microsoft Excel.

    5. On the File menu, click Save.

  11. Restart the BizTalk Application service.

    1. Open services.msc.

    2. Right-click the BizTalk Service BizTalk Group: BizTalkServerApplication service, and then Start.

  12. Enable any BAM cube update and data maintenance DTS packages.

  13. To resolve any incomplete trace instances, see Resolve Incomplete Activity Instances.

See Also

Backing Up and Restoring BAM