Recovering SYSTEMDB with 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 the Recovering an SAP HANA Database section of the SAP HANA Administration Guide.

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.

Recovering SYSTEMDB with SAP HANA Cockpit 

  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.

Recovering SYSTEMDB with SAP HANA Cockpit 

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.

Recovering SYSTEMDB with SAP HANA Cockpit 

  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.

Recovering SYSTEMDB with SAP HANA Cockpit 

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

Recovering SYSTEMDB with SAP HANA Cockpit 

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

Recovering SYSTEMDB with SAP HANA Cockpit 

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

Recovering SYSTEMDB with SAP HANA Cockpit 

  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.

Recovering SYSTEMDB with SAP HANA Cockpit 

  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.

Recovering SYSTEMDB with SAP HANA Cockpit 

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

Recovering SYSTEMDB with SAP HANA Cockpit 

  1. Review the recovery options and click Start Recovery.

Recovering SYSTEMDB with SAP HANA Cockpit 

I want to report a typo

There is a misspelling right here:

 

I want to let the Veeam Documentation Team know about that.