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.

Perform a SAP HANA Restore

You can use any of the following tools to perform a restore:

  • CommCell Console
  • DBA Cockpit
  • SAP HANA Studio Interface
  • SQL Console of SAP HANA Studio
  • hdbsql command from the Command Line Interface

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 a different tenant SID from 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: 3/10/2018 7:57:56 PM