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
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 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