Running a restore (recovery) job with SAP HANA Studio

After an SAP HANA database has been backed up using the DPX plugin, it can be restored.

Before you begin

One or more databases must be registered and properly configured in SAP HANA Studio before a backup job can be initiated.

One or more backup jobs must have already been completed successfully.

About this task

SAP HANA Studio is used to initiate backup and restore (recovery) jobs. The DPX plugin may be used to monitor the progress of jobs but should never be used to initiate backup or restore jobs.

Procedure

  1. Right-click the SAP HANA system and select Backup and Recovery.

  2. Select Recover System Database or Recover Tenant Database. Select the SAP HANA system database or tenant database.

  3. Click Next. The Specify Recovery Type dialog will appear.

  4. Specify the recovery type. For example, if performing a point-in-time (PIT) recovery, select Recover the database to the following point in time. Enter a Date, a Time, and select the time zone from the Select Time Zone selection field.

Tip. The date and time selection should be within the defined range of when the point in time was started.

  1. Click Next. The Locate Backup Catalog dialog will appear.

  2. Select Recover using the backup catalog and Search for the backup catalog in Backint only.

  3. Click Next. The Select a Backup dialog will appear.

  4. Select the desired backup. For example, if PIT was selected, select a backup based on the Start Time that is marked as Available. If you do not see the backup listed, click the Refresh button or the Show More button if several backups are listed.

  5. Click Next. The Locate Log Backups dialog will appear.

  6. Click Next. The Other Settings dialog will appear. Ensure File System, Third-Party Backup Tool (Backint), and Use Delta Backups (Recommended) is selected.

  7. Click Next. The Review Recovery Settings dialog will appear. Review the selections and click Back if any revisions are necessary.

  8. Click Finish. The Recovery Execution Summary will appear.

  9. Click Close.

Results

The restore job will begin.

Last updated