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.

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: 3/10/2018 8:02:07 PM