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:

In the SAP HANA Cockpit console, locate the database that you want to recover.

In the Overall Database Status block, click Stop System.

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

Performing Recovery

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

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

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.

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

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

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

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.

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.

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.

Review the recovery options and click Start Recovery.