Restoring a Backup from the Backup History 

You can use the Recovery Wizard to restore interactively. You can perform a recovery with a complete data backup from the backup history.

Prerequisites

The log files dbm.knl and dbm.mdf of the Database Manager exist and are not damaged. This means that the backup history is complete.

If you are restoring with backup tools from other providers, the log file dbm.ebf must also exist and not be damaged.

The database instance is in the ADMIN operational state.

Procedure

Use the Recovery Wizard.

...

       1.      Choose Restore a specified backup from history.
You can now choose a time up to which you want to restore data. In this case, select Restore database until a specified time and enter a time.
The system default is the current time. If you do not change the time proposed by the system, the database instance is restored completely, including all changes.

       2.      The backup history for all data backups is displayed.

       3.      Select the data backup you require.

       4.      The chosen data backup, the corresponding incremental data backup, and the required log backups are displayed.
You can remove the incremental data backup from the proposal. If you do this, the Recovery Wizard proposes the corresponding log backups, or another incremental data backup (if one exists).

       5.      The system prompts you to insert the specified data carrier.

       6.      Start the recovery.
If you are performing a restore using backup tools from other providers, the external backup IDs are displayed at this point.
The complete data backup is restored.

       7.      If you are restoring an incremental data backup, the Recovery Wizard prompts you to confirm this.

       8.      If you need to restore log backups, the Recovery Wizard prompts you to confirm that you want to restore all the log backups displayed. After the log backups have been restored, the database instance is in the ONLINE operational state.
If no log backups need to be restored, the recovery is complete. You can also specify an UNTIL time. Choose Restart to start the database instance.

When you restore a series of backups, the Recovery Wizard prompts you to insert the next backup data carrier each time, unless you are restoring from an automatic tape loader.

You can, if you wish, stop the restore process and resume it later on (see Continue Interrupted Restore).