description | title | ms.custom | ms.date | ms.service | ms.reviewer | ms.suite | ms.topic |
---|---|---|---|---|---|---|---|
Learn how to move the Business Activity Monitoring (BAM) Primary Import database to another server. |
How to Move the BAM Primary Import Database1 |
06/08/2017 |
biztalk-server |
article |
You can use this procedure to move the BAM Primary Import database to another server.
You must be logged on with an account that is a member of the SQL Server sysadmin fixed server role to perform this procedure.
-
Stop all BizTalk Server services. For more information, see How to Start, Stop, Pause, Resume, or Restart BizTalk Server Services.
-
Stop the IIS service.
-
Stop the BAM Alerts Notification Service:
-
Click Start, click Run, type cmd, and then click OK.
-
At the command prompt, type:
Net stop NS$BamAlerts
-
-
Follow the instructions in SQL Server Books Online to back up the BAM Primary Import database on the old server.
-
Copy the BAM Primary Import database to the new SQL Server.
-
Follow the instructions in SQL Server Books Online to restore the BAM Primary Import database on the new server.
-
On a computer running [!INCLUDEbtsBizTalkServerNoVersion], browse to the following folder:
[!INCLUDEbtsBiztalkServerPath]Schema\Restore
-
Right-click SampleUpdateInfo.xml, and then click Edit.
-
In the Primary Import Database section of the file, replace "SourceServer" with the name of the source system, and then replace "DestinationServer" with the name of the destination system.
[!IMPORTANT] Include the quotation marks around the name of the source and destination systems.
[!NOTE] If you renamed any of the BizTalk Server databases, you must also update the database names as appropriate.
-
Uncomment the following lines in the xml file:
- <UpdateConfiguration> <MessageBoxDB oldDBName="BizTalkMsgboxDb" oldDBServer="Server01" newDBName="BizTalkMsgboxDb" newDBServer="Server01" IsMaster="1" /> <TrackingDB oldDBName="BizTalkDTADb" oldDBServer="Server01" newDBName="BizTalkDTADb" newDBServer="Server01" /> <ManagementDB oldDBName="BizTalkMgmtDb" oldDBServer="Server01" newDBName="BizTalkMgmtDb" newDBServer="Server01" /> - <BAM> - <DeploymentUnit Name="OldPrimaryImportDatabase"> <Property Name="ServerName">Server01</Property> <Property Name="DatabaseName">BAMPrimaryImport</Property> </DeploymentUnit> - <DeploymentUnit Name="PrimaryImportDatabase"> <Property Name="ServerName">Server02</Property> <Property Name="DatabaseName">BAMPrimaryImport</Property> </DeploymentUnit> - <DeploymentUnit Name="ArchivingDatabase"> <Property Name="ServerName">Server01</Property> <Property Name="DatabaseName">BAMArchive</Property> </DeploymentUnit> - <DeploymentUnit Name="AnalysisDatabase"> <Property Name="ServerName">Server01</Property> <Property Name="DatabaseName">BAMAnalysis</Property> </DeploymentUnit> - <DeploymentUnit Name="StarSchemaDatabase"> <Property Name="ServerName">Server01</Property> <Property Name="DatabaseName">BAMStarSchema</Property> </DeploymentUnit> - <DeploymentUnit Name="Alert"> <Property Name="DBServer">Server01</Property> <Property Name="InstanceDatabaseName">BAMAlerts</Property> </DeploymentUnit> </BAM> - <OtherDatabases> <Database Name="SSO" oldDBName="SSODB" oldDBServer="Server01" newDBName="SSODB" newDBServer="Server01" /> </OtherDatabases> </UpdateConfiguration>
-
When you are finished editing the file, save it and exit.
-
Click Start, click Run, type cmd, and then click OK.
-
At the command prompt, navigate to the following directory:
[!INCLUDEbtsBiztalkServerPath]Schema\Restore
-
At the command prompt, type:
cscript UpdateDatabase.vbs SampleUpdateInfo.xml
-
Update the reference to BAM Primary Import Database in all BAM Livedata Microsoft Excel files. For each file:
-
Open the Excel live data file. The file name ends with _LiveData.xls.
-
On the BAM menu, click BAM DB Connection.
-
In the Select BAM Database dialog box, enter the SQL Server and BAMPrimaryImport database, and then click OK.
-
On the File menu, click Close and Return to Microsoft Excel.
-
On the File menu, click Save.
-
-
Update the server and database names in all BAM analysis DTS packages, which are prefixed with "BAM_AN_" or "BAM_DM_" by following these steps:
-
On the server hosting BAM, open SQL Server Enterprise Manager.
-
Open the Data Transformation Services folder.
-
Open the Local Packages folder, and then open the DTS packages.
-
On the Package menu, click Properties.
-
On the Global Variables tab, update the values for the primary import server and database.
-
Change the following lines to match your new server and database:
PrimaryImportServer= "<ServerName>"
PrimaryImportDatabase = "<DatabaseName>"
-
-
Start all BizTalk Server services. For more information, see How to Start, Stop, Pause, Resume, or Restart BizTalk Server Services.
-
Start the IIS service.
-
Start the BAM Alerts Notification Service:
-
Click Start, click Run, type cmd, and then click OK.
-
At the command prompt, type:
Net start NS$BamAlerts
-