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