BizTalk : How To : Restore Your backup BizTalk Databases

Friday, April 12, 2013

How to Restore Your BizTalk Databases

1.     On the computer or computers that you have identified as the destination system, click Start, click Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.
2.     In the Connect to Server dialog box, specify the name of the SQL Server on the destination system, and then click Connect to connect to the appropriate SQL Server.
3.     In Microsoft SQL Server Management Studio, double-click the appropriate server, double-click SQL Server Agent, and then double-click Jobs.
4.     In the details pane, right-click BTS Log Shipping - Get Backup History, and then click Disable.
In the Disable Jobs dialog box, the status changes to Success.
5.     In the details pane, right-click BTS Log Shipping - Restore Databases, and then click Disable.
In the Disable Jobs dialog box, the status changes to Success.
6.     In the details pane, right-click BTS Log Shipping - Restore To Mark, and then click Start Job.
SQL Server Agent jobs and BizTalk Server databases are restored to the destination system.
7.     On the computer running BizTalk Server 2006, where you edited the SampleUpdateInfo.xml file, open a command prompt. Click Start, click Run, type cmd and then click OK.
8.     Navigate to the following directory: %SystemRoot%\Program Files\Microsoft BizTalk Server 2006\Schema\Restore.

Description: http://i.msdn.microsoft.com/Aa546753.note(en-us,MSDN.10).gifNote
On 64-bit computers, browse to the following folder: %SystemRoot%\Program Files (x86)\Microsoft BizTalk Server 2006\Bins32\Schema\Restore.

9.     At the command prompt, type:
cscript UpdateDatabase.vbs SampleUpdateInfo.xml
This script updates all tables that store information about the location of other databases.

Description: http://i.msdn.microsoft.com/Aa546753.note(en-us,MSDN.10).gifNote
You only need to run UpdateDatabase.vbs on one server in the BizTalk group.
Description: http://i.msdn.microsoft.com/Aa546753.note(en-us,MSDN.10).gifNote
On 64-bit computers, you must run UpdateDatabase.vbs from a 64-bit command prompt.

10.  Copy the edited SampleUpdateInfo.xml file to the %SystemRoot%\Program Files\Microsoft BizTalk Server 2006\Schema\Restore directory on every computer running BizTalk Server 2006 that is part of the BizTalk Server group.

Description: http://i.msdn.microsoft.com/Aa546753.note(en-us,MSDN.10).gifNote
On 64-bit computers, browse to the following folder: %SystemRoot%\Program Files (x86)\Microsoft BizTalk Server 2006\Bins32\Schema\Restore.

11.  On each computer in the BizTalk Server group, open a command prompt. Click Start, click Run, type cmd and then click OK.

12.  Navigate to the following directory: %SystemRoot%\Program Files\Microsoft BizTalk Server 2006\Schema\Restore.

Description: http://i.msdn.microsoft.com/Aa546753.note(en-us,MSDN.10).gifNote
On 64-bit computers, browse to the following folder: %SystemRoot%\Program Files (x86)\Microsoft BizTalk Server 2006\Bins32\Schema\Restore.

13.  At the command prompt, type:
cscript UpdateRegistry.vbs SampleUpdateInfo.xml
This script updates all registry entries that store information about the location of other databases.

Description: http://i.msdn.microsoft.com/Aa546753.note(en-us,MSDN.10).gifNote
You need to run UpdateRegistry.vbs on every server in the BizTalk group.
Description: http://i.msdn.microsoft.com/Aa546753.note(en-us,MSDN.10).gifNote
On 64-bit computers, you must run UpdateRegistry.vbs from a 64-bit command prompt.

14.  Restart all of the BizTalk Server services. For more information about how to restart the BizTalk Server services, see How to Start, Stop, Pause, Resume, or Restart BizTalk Server Services.

15.  After restoring your databases, you must restart the Windows Management Instrumentation service. Click Start, click Run, type services.msc, and then click OK. Right-click Windows Management Instrumentation, and then click Restart.
16.  On the computer you use to administer BizTalk Server, click Start, click Programs, click Microsoft BizTalk Server 2006, and then click BizTalk Server Administration.
17.  In the console tree, right-click the BizTalk Group, and then click Remove.
18.  In the console tree, right-click BizTalk Server 2006 Administration, and then click Connect to Existing Group.
19.  In the Connect to Existing BizTalk Server Configuration Database dialog box, in the SQL Server name drop-down list box, select the name of the Microsoft SQL Server instance that hosts the BizTalk Management database. When you select the instance of SQL Server, BizTalk Server automatically attempts to detect BizTalk Server databases on that computer.
20.  In the Database name drop-down list box, select the BizTalk Management database (BizTalkMgmtDb) to which you want to connect, and then click OK.
The BizTalk Server Administration Console adds the BizTalk group to the console tree.
Your BizTalk server is now restored and should be running. You should now configure the Backup BizTalk Server job to start writing backups to a new destination server. You should also reconfigure a new destination system.

Description: http://i.msdn.microsoft.com/Aa546753.Important(en-us,MSDN.10).gifImportant
If you are using the Rules Engine, after restoring the databases, you must restart the Rule Engine Update Service on every server in the BizTalk Server group. For more information about how to restart the Rule Engine Update Service, see How to Start, Stop, Pause, Resume, or Restart BizTalk Server Services.

Description: http://i.msdn.microsoft.com/Aa546753.note(en-us,MSDN.10).gifNote
If you are using BAS or BAM, this is the time to restore the BAS and BAM databases. For more information, see Backing Up and Restoring BAS and Backing Up and Restoring BAM.

No comments:

Post a Comment

Post Your Comment...