Restoring the Rule Engine Database

If you backed up your Rule Engine database, in the event of a disaster, you can restore that backup to a different computer, and assign the backup a new database name.

To restore the Rule Engine database, perform the steps in Restoring Your Databases. In addition, you must update the BizTalk Configuration database with the new Rule Engine database name, and update the Rule Engine database subkeys in the registry.

To update references to the Rule Engine database name

  1. Using SQL Enterprise Manager, open the BizTalk Configuration database.
  2. In the adm_Group table, modify the columns corresponding to the original database to reference the appropriate values for the new database.

    <DBType>DBServerName and <DBType>DBName indicate the location of the database, where <DBType> corresponds to the type of the database: RuleEngine.

  3. Click Start, and then click Run. Enter regedit, and then click OK.
  4. In the Registry Editor, move to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\BusinessRules\3.0 key. Set the DatabaseServer and DatabaseName subkeys to the appropriate values for the new Rule Engine database.

See Also

Scheduling Database Backups

Restoring BizTalk Databases to Alternate Computers

To download updated BizTalk Server 2004 Help from, go to

Copyright © 2004 Microsoft Corporation.
All rights reserved.