Restoration

You can use SAP HANA Studio, SAP HANA Cockpit, or SAP HANA HDBSQL to restore the data for SAP HANA.

The following use a case where SAP HANA Studio is used to restore the data in SAP HANA 2.0 and Backint Agent is deployed to make full backup for data, catalog, and log and store the backups to OBS as an example to describe the restoration procedure.

1. Open SAP HANA Studio, right-click the system which data restoration needs to be performed for on the left, choose Backup and Recovery, and select an option based on the actual requirements:

• Recovery System Database
• Recovery Tenant Database

2. For example, to restore the data in the tenant database, select a tenant database and select a restoration type:

• Recover the database to its most recent state
• Recover the database to the following point in time
• Recover the database to a specific data backup

3. For example, to restore the database to its most recent state, select Search for the backup catalog in Backint only in Recover using the backup catalog.

4. The tenant database needs to be shut down during the restoration. In the dialog box that is displayed, click OK.

5. After selecting a backup file, you can click Check Availability to check whether the backup file is available. If the icon turns into green, the backup file is available. Click Next. Confirm the information and click Next.

6. If you want to check the availability of differential backups and log backups during the restoration, select Third-Party Backup Tool (Backint) and click Next.

7. Confirm the information restored and click Finish. If the installation and configuration are successful, the restoration progress is displayed until the restoration is complete.