Restoring and recovering data

Edit online

To restore or recover data with Data Protection for SAP HANA, start the SAP HANA Studio.

About this task

SAP HANA supports multiple sessions for backup and restore operations. In earlier versions, IBM Storage® Protect for ERP was restricted to using a single session to do a restore operation because the objects had to be restored in the same order as they appeared in the INIFILE.

In the setup script, you can enter the number of sessions to the IBM Storage Protect server that you want to use, and both IBM Storage Protect for ERP and SAP HANA configurations are adjusted accordingly. For more information, see Configuring Data Protection for SAP HANA with the setup script.

Procedure

  1. In the SAP HANA Studio Navigator tab, right-click to select the instance. Select Recovery.
    If the database instance is still running, a message might be displayed. The message states that the system must be shut down. When you confirm the message, SAP HANA Studio automatically shuts down the instance.
  2. In the Specify Recovery Type window, choose the type of recovery that you want to run.
  3. In the Locate Log Backups panel the default location can be used.
  4. Choose the backup to restore in the Select Data Backups panel. The list of backups is generated from the SAP HANA recovery catalog. This catalog contains every backup that is created. By selecting a specific backup and pressing Check Availability it can be verified that the backup exists on the IBM Storage Protect server.
  5. Advance through the panels, and select the options that you require.

What to do next

For more information about restoring and recovering data, see the SAP HANA documentation.