Restoring SYSTEMDB (SAP HANA Cockpit)

You can restore SAP HANA SYSTEMDB databases from the Veeam Plug-in backups using SAP HANA Cockpit.

The example below is provided for demonstration purposes only. For details on the full restore functionality of SAP HANA Cockpit, see this SAP article.

Before You Begin

Before you start the recovery, shut down the database that you want to recover:

  1. In the SAP HANA Cockpit console, locate the database that you want to recover.
  1. In the Overall Database Status block, click Stop System.

Overall Database Status

  1. At the Manage Services section, click Stop System and select the Softly option to shut down the database after SAP HANA finishes running statements.

Manage Services

Performing Recovery

To perform a Backint recovery of SYSTEMDB from a Veeam Plug-in backup, do the following:

  1. In the System Overview block, go to the Database Administration section and click Recover database.

System Overview

  1. At the Recovery Target step, select the required restore point or the option to restore the database to the most recent state. Then, click Step 2.

Recovery Target

  1. Specify the location of the latest backup catalog and click Step 3.

Specify Backup Location

  1. At the Backup to be Used step, select the backup and click Step 4.

Backup to be Used

  1. At the Delta Backups step, select Yes to use delta backups.

Delta Backups

  1. At the Specify Alternative Backup Locations step, if you want to use backups that are not in the backup catalog, specify their locations. You can also change the location for log backups.

If you you leave the fields empty, SAP HANA will use the locations specified in the backup catalog.

Specify Alternative Backup Locations

  1. At the Check Availability of Backups step, select Yes or No options, to check if the backups are available. Note that at this step SAP HANA does not check the integrity of the backup content on the block level.

Check Availability of Backups

  1. At the Initialize Log Area step, select No to initialize the log area and click Review. You must initialize the log area only if the log area is unavailable or if you are recovering the database to a different system.

Initialize Log Area

  1. Review the recovery options and click Start Recovery.

Review Recovery Options

Page updated 3/21/2024

Page content applies to build