Loading...

SAP HANA Multitenant Database Container Restores

A database restore might be necessary when the data area or the log area is damaged, to recover from a logical error or to copy the database. This can be achieved by using data and log backups.

Perform a restore operation immediately after your first full backup to understand the process.

Note: After you upgrade to HANA 2.0, to restore HANA 1.0 databases, use the BACKINT interface on SAP HANA studio.

SYSTEMDB Database Restores

You can recover a SYSTEMDB database to the latest backup.

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

  • Restore to a new destination that has the same SYSTEMDB SID as the source
  • Restore to a new destination that has a different SYSTEMDB SID from the source

Note: You cannot restore a SYSTEMDB database to a tenant database

Tenant Database Restores

You can restore a tenant database to the latest backup, or to a point-in-time.

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

  • Restore to a new destination that has the same tenant SID as the source
  • Restore to a new destination that has the same tenant SID as the source and a different SYSTEMDB SID from the source

Note: You cannot restore a tenant database to a SYSTEMDB database

Last modified: 8/5/2020 8:49:04 PM