Edit

How to Update References to the BAM Archive Database Name

  • Article

If you backed up your BAMArchive databases, in the event of a system or data failure you can restore that backup and rename it.

To restore the BAMArchive databases, 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 BAM DTS packages with the new server name and database name.

Prerequisites

You must be logged on as a member of the BizTalk Server Administrators group to perform this procedure.

To update references to the BAM Archive database name (SQL Server 2008 R2/SP1)

  1. Stop any BAM cube update and data maintenance DTS packages, or prevent them from running until you have restored the BAMArchive 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. Click Start, click Run, and then type services.msc.

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

  3. Click Start, click Programs, click Microsoft SQL Server 2008 R2, and then click SQL Server Business Intelligence Development Studio.

  4. In SQL Server Business Intelligence Development Studio, create a new project. Click File, click New, and then click Project.

  5. In the New Project dialog box, in Templates, click Integration Services Project, and then click OK.

  6. In the Integration Services Project dialog box, in Solution Explorer, right-click SSIS Packages, and then click Add Existing Package.

  7. In the Add Copy of Existing Package dialog box, in the Server drop-down list box, select the server that contains the BAM_DM package.

  8. In Package Path, click the ellipses button.

  9. In the SSIS Package dialog box, select the BAM_DM package, click OK, and then click OK.

    The package is now listed in Solution Explorer.

  10. In Solution Explorer, double-click the BAM_DM package. In Connection Managers, double-click database number 3 (MSDB database).

  11. In the Connection Manager dialog box, in the Server name box, enter the name of the MSDB server, and then click OK.

  12. Click the Package Explorer tab, double-click the Variables folder, and then update the values for the primary import server name and primary import database name.

  13. Click File, and then click Save All.

  14. In Microsoft SQL Server Management Studio, click Connect.

  15. Click Integration Services, double-click Stored Packages, click MSDB, right-click the BAM_DM package, and then click Import Package.

  16. In the Import Package dialog box, in Package location, select File System.

  17. In Package Path, navigate to your saved project, select the BAM_DM*.dtsx file, and then click Open.

  18. Click inside the Package Name box to automatically populate the box.

  19. Click OK, and then click Yes to overwrite.

  20. Restart the BizTalk Application service.

    1. Click Start, click Run, and then type services.msc.

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

  21. Enable any BAM cube update and data maintenance SSIS packages.

See Also

Backing Up and Restoring BAM