Export (0) Print
Expand All

How to Move the BAM Analysis Database

You can use this procedure to move the BAM Analysis database to another server. From an end-to-end scenario perspective, moving the BAM Analysis database involves two major steps:

You must be logged on with an account that is a member of the SQL Server sysadmin fixed server role to perform this procedure.

Perform the steps in the following procedure to move the BAM Analysis database.

  1. Stop any BAM cube update and data maintenance SSIS packages, or prevent them from running until you have restored the BAM Analysis database.

  2. Stop all BizTalk Server services. For more information, see the topic How To Start, Stop, Pause, Resume, or Restart BizTalk Server Services (http://go.microsoft.com/fwlink/?LinkId=154394) in BizTalk Server 2009 Help.

  3. Stop the IIS service.

  4. Stop the BAM Alerts Notification service:

    1. Click Start, click Run, type cmd, and then click OK.

    2. At the command prompt, type:

      Net stop NS$BamAlerts

  5. Back up the BAM Analysis database on the old server. For instructions on backing up a database, follow the instructions at How to: Back Up a Database (SQL Server Management Studio) (http://go.microsoft.com/fwlink/?LinkId=156510) in SQL Server Books Online on how to back up a database.

  6. Copy the BAM Analysis database to the new SQL Server computer.

  7. Restore the BAM Analysis database on the new server. For instructions on restoring the database, follow the instructions at How to: Restore a Database Backup (SQL Server Management Studio) (http://go.microsoft.com/fwlink/?LinkId=156511) in SQL Server Books Online on how to restore a database.

After you have moved the database, you must update all the references to the new BAM Analysis Database. The following references must be updated:

  1. Get a copy of the .xml file used for restoring BAM:

    1. Click Start, click Run, type cmd, and then click OK.

    2. On a computer running BizTalk Server 2009, browse to the following folder:

      • If BizTalk Server is installed on a 64-bit version of Windows Server:

        %ProgramFiles(x86)%\Microsoft BizTalk Server 2009\Tracking

      • If BizTalk Server is installed on a 32-bit version of Windows Server:

        %ProgramFiles%\Microsoft BizTalk Server 2009\Tracking

    3. At the command prompt, type:

      Bm.exe get-config –filename:BAMConfiguration.xml -server:<servername> -database:<database>

      Ee308912.note(en-US,BTS.10).gifNote
      When running this command, substitute the actual name of the server from which to get the configuration information for <servername> and substitute the actual name of the database from which to get the configuration information for <database>. For more information about using the BAM Management (BM) utility, see Infrastructure Management Commands (http://go.microsoft.com/fwlink/?LinkId=156516) in BizTalk Server 2009 Help.

  2. Edit the BAMConfiguration.xml file and change the ServerName in the <DeploymentUnit Name="AnalysisDatabase"> section to the new server name.

  3. Save and close the BAMConfiguration.xml file.

  4. Click Start, click Run, type cmd, and then click OK.

  5. On a computer running BizTalk Server 2009, browse to the following folder:

    • If BizTalk Server is installed on a 64-bit version of Windows Server:

      %ProgramFiles(x86)%\Microsoft BizTalk Server 2009\Tracking

    • If BizTalk Server is installed on a 32-bit version of Windows Server:

      %ProgramFiles%\Microsoft BizTalk Server 2009\Tracking

  6. At the command prompt, type:

    bm.exe update-config -FileName:BAMConfiguration.xml

  1. Update the server and database names in all BAM analysis SSIS packages, which are prefixed with "BAM_AN_". To do so, click Start, click All Programs, click Microsoft SQL Server 2005 or Microsoft SQL Server 2008, and then click SQL Server Business Intelligence Development Studio.

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

  3. In the New Project dialog box, in the Project Types box, click Business Intelligence Projects. On the right pane, in the Templates box, click Integration Services Project, and then click OK.

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

  5. In the Add Copy of Existing Package dialog box, in the Server drop-down list box, select the server that contains the BAM_AN_* packages.

  6. In Package Path, click the ellipses button.

  7. In the SSIS Package dialog box, select the package you want to update, click OK, and then click OK.

    The package is now listed in Solution Explorer.

  8. In Solution Explorer, double-click the package you added in the previous step. In Connection Managers tab (available towards the lower half of the screen), double-click data source number 2 (BAMArchive database).

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

    Ee308912.note(en-US,BTS.10).gifNote
    Repeat this for data source number 3 (MSDB database).

  10. In the Connection Managers tab, double-click data source number 4 (BAMAnalysis database). In the Add Analysis Services Connection Manager dialog box, click Edit.

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

  12. Click the Package Explorer tab, double-click the Variables folder, and then update the values for the AnalysisDatabase, AnalysisServer, PrimaryImportDatabase, PrimaryImportServer, StarSchemaDatabase, and StarSchemaServer variables. You must update the values to point to the new server and database.

    Ee308912.note(en-US,BTS.10).gifNote
    Repeat step 4 through 12 for all the packages that you want to update.

  13. Click then File menu, and then click Save All.

  14. Start the SQL Server Management Studio. Click Start, click All Programs, click Microsoft SQL Server 2005 or Microsoft SQL Server 2008, and then click SQL Server Management Studio.

  15. In the Connect to Server dialog box, from the Server type drop-down list, select Integration Services.

  16. Specify the server name and credentials to connect to the server and click OK.

  17. In the Object Explorer, expand Integration Services, expand Stored Packages, and then click MSDB.

  18. In the Object Explorer Details tab, right-click the package that you updated earlier and then click Import Package.

  19. In the Import Package dialog box, from the Package location drop-down list, select File System.

  20. In Package Path, navigate to your saved project, select the .dtsx file for the package you want to import, and then click Open.

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

    Ee308912.note(en-US,BTS.10).gifNote
    Repeat step 18 through 21 for all the packages that you want to update.

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

  23. Start all BizTalk Server services. For more information, see the topic How To Start, Stop, Pause, Resume, or Restart BizTalk Server Services (http://go.microsoft.com/fwlink/?LinkId=154394) in BizTalk Server 2009 Help.

  24. Start the IIS service.

  25. Start the BAM Alerts Notification service:

    1. Click Start, click Run, type cmd, and then click OK.

    2. At the command prompt, type:

      Net start NS$BamAlerts

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

Show:
© 2014 Microsoft