Restoring a SAP HANA Tenant Database

Restore a tenant database.

If you need to restore a SYSTEMDB database and tenant databases, perform the SYSTEMDB database restore first, and then restore the tenant databases.

You can restore to the same destination, or to the following new destinations:

  • An in-place restore
  • Restore to a different SID. The destination SID must topology as the source SID. You can restore to a database name that is different from the source database name.

If you want to recover only the data, then you must perform the restore by using a full backup.

Note: Do not run a tenant database restore when a SYSTEMDB database restore is in progress.

Before You Begin

  1. Perform a full backup or perform an incremental backup.
  2. Verify that the tenant databases that you want to restore already exist.
  3. If you need to restore a SYSTEMDB database and tenant databases, restore the system database.
  4. Verify that the restore environment has the same set of nodes and the instance as the backup environment. If you modify the configuration file in the backup environment, then make the same modifications in the restore environment before starting the recovery process.
  5. Verify that the SAP HANA software version that is used for restore is of the same version or later than the software version used during backup.
  6. If you recover the data only, make sure that you have the backup prefix for the tenant database. If you use the SYSTEMDB database backup prefix, the restore fails.


  1. From the CommCell Browser, expand Client Computers > pseudo-client > SAP HANA.
  2. Right-click the instance, point to All Tasks, and then click Browse and Restore.
  3. On the Browse and Restore dialog box, select Latest Backup and click View Content.
  4. From the Browse window, select a tenant database in the right pane, and then click Recover All Selected.

    The Restore Options dialog box appears.

  5. On the General tab, select the destination client and instance:
    1. From the Destination Client list, select the client that you want to restore to.
    2. From the Destination Instance list, select the instance that you want to restore to.
    3. If you want to restore the tenant database to a different tenant database name than the source, then from the Database Name list, select the new tenant database.
  6. On the General tab, select the type of restore that you want to perform:

    Recover the database to the most recent state

    Recover to a point-in-time

    Recover only the data

  7. To verify that all the backups required for the recovery operation are available, select the Check Access check box.
  8. Select the Initialize log area check box.

    The software selects the check box when you choose Recover data only.

    Make sure that you select this check box when you choose  Most Recent State or Point in Time.

  9. Select the Use Delta Backups check box.

    For information on the delta backup option, see SAP HANA Restore Options.

  10. Optional: Restore from a copy precedence.

    If the backup is corrupted, restore from a storage policy copy.

    For more information on modifying the copy precedence of a storage policy copy, see Copy Precedence.

    1. Click Advanced.

      The Advanced Restore Options dialog box appears.

    2. On the Copy Precedence tab, select the Restore from Copy Precedence number check box and enter a copy precedence number.
    3. Click OK to close the Advanced Restore Options dialog box.
  11. Click OK to close the Restore Options dialog box and start the restore.

What to Do Next

If you only restored the tenant database, after the restore the tenant database is in the Up state.

Last modified: 11/27/2018 8:23:03 PM