This is an archive version of the document. To get the most up-to-date information, see the current version.

Recovering Databases Using SQL Commands or Scripts

You can use HDBSQL to restore SAP HANA databases from backups stored on Veeam backup repositories. For details on the HDBSQL restore, see the RECOVER DATABASE Statement section of the SAP HANA SQL and System Views Reference.

To recover SAP HANA databases from backups stored on Veeam backup repositories, do the following:

Log in to SAP HANA HDBSQL as the HDB administrator. Use HDBUSERSTORE to securely store connection details on a client machine.

sh4adm@linux-q0pn:/usr/sap/SH4/HDB01> hdbuserstore SET <key> hostname:30013@SID <username> <password>

sh4adm@linux-q0pn:/usr/sap/SH4/HDB01> hdbsql -U <key>

Recover a tenant database to the latest state using Backint. As the timestamp, specify the current data and time or future date and time.

alter stop database <DATABASE_NAME>;

recover database for <DATABASE_NAME> until timestamp '2020-01-01 12:00:00' using catalog backint;