Restoring and Upgrading the History Database

Scenario
You have an HDB backup that you want to restore. The HDB backup can be of the same version as that of the current SQL Server version or it can have the lower version. For information on restoring and upgrading the notification database, see Restoring and Upgrading the Notification Database (NDB).

In case of the same version, once the HDB backup is restored you can directly link it to the project.

If the HDB that you are about to restore has the lower version than that of the current SQL Server version, then after restore you must first stop the HDB, upgrade it to the version of the SQL Server, start the HDB and thereafter link it to the project.

For background information, see the reference section.

Prerequisites

• The Windows user configured in the System Account and in the HDB Service Account must be valid and assigned all required rights, See Log on as a Service Right in System Settings Procedures.
• SMC must be launched, the following prerequisites apply :
• The required Windows account configured on SQL Server with sysadmin fixed server role is available.
• If the required privileges are not available a dialog box appears to provide a Windows account configured on the SQL Server with sysadmin fixed server role.
• SMC launched with a Windows HDB owner user when HDB workflow do not need system administrator privileges.
• HDB workflows such as change HDB owner, which need system administrator privileges, a dialog box displays to provide a user having system administrator privileges on the SQL Server.
• A HDB backup is available at the known path.

Overview