5 1 0:SAP HANA Restore

From SEPsesam

Welcome to the latest SEP sesam documentation version 5.1.0 Apollon. For previous documentation version(s), check documentation archive.


SEP sesam HDBBackint integration provides efficient backup and restore of your SAP HANA environment. Recovering a SAP HANA instance can easily be accomplished using SAP HANA studio. You can recover the database to the latest version or to a specific point in time, restore it to the same or a different client.

Before you begin a SAP HANA recovery, make sure that you have performed your backup as required. For more details, see SAP HANA Backup.

Single schema restore for SAP Business One (below version 10!)

SAP HANA does not support selective restore of a single database schema into the database. While database schemas are used massively for multi-tenancy on hosted SAP Business One installations, there is only one possibility to get back data in a single schema in case of a recovery.

  1. Prepare the SAP HANA installation as big in size as the productive one.
  2. Restore the database following the steps below.
  3. Start the database in an isolated environment.
  4. Export the schema you need to restore via SAP HANA studio.
  5. Import the schema data on the productive SAP HANA environment.

Restoring SAP HANA

In case of a disaster recovery, restore the operating system or start with a fresh SAP HANA installation and execute the SEP sesam HANA module installation as described in SAP HANA Backup. Then start the SAP HANA Studio.

  1. In the SAP HANA System view, right-click your server/instance and select Recover... The SAP HANA recovery wizard starts.
  2. Note
    Opening the recovery wizard will shut down the database.

    SAP HANA Studio - Systems view

  3. Specify the recovery type. In our example, we have selected the most likely used recovery type that applies in most cases – point-in-time recovery.
  4. SAP HANA recovery wizard
  5. Specify the backup location.
  6. Note
    Backint System Copy option can be used to restore backups from a system with a different identifier (SID). A typical use case for this feature is to restore a data backup from the productive system to a test instance.

    Click Next.

  7. A list of the available backups is displayed. Specify which backup should be used to restore. To ensure that the backup is still stored on the SEP sesam media, select the backup and click Check Availability thus triggering an inquiry to the SEP sesam Server. Once you have selected your backup, click Next.
  8. SAP HANA recovery wizard
  9. The wizard now provides some additional options: You can choose to let the system perform availability check for log backups, trigger a purge of the log area during the restore and install a new license key (required if you are restoring to a fresh, plain system). Click Next.
  10. SAP HANA recovery wizard
  11. Review the summary of the recovery settings. Click Finish to begin the restore.
  12. SAP HANA recovery wizard
    The recovery progress is displayed in a status window.
    SAP HANA recovery status

If the recovery is successful, the message System <SID> recovered is displayed and the database is ready for use again. For more information, see the SAP HANA documentation.

See also

SAP HANA BackupCreating a Backup Copy of an SAP HANA DatabaseSAP HANA Administration Guide

Copyright © SEP AG 1999-2024. All rights reserved.
Any form of reproduction of the contents or parts of this manual is allowed only with the express written permission from SEP AG. When compiling and designing user documentation SEP AG uses great diligence and attempts to deliver accurate and correct information. However, SEP AG cannot issue a guarantee for the contents of this manual.