Restoring SYSTEMDB (SAP HANA Cockpit)

In this article

    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.

    Restoring SYSTEMDB (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.

    Restoring SYSTEMDB (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.

    Restoring SYSTEMDB (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.

    Restoring SYSTEMDB (SAP HANA Cockpit) 

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

    Restoring SYSTEMDB (SAP HANA Cockpit) 

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

    Restoring SYSTEMDB (SAP HANA Cockpit) 

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

    Restoring SYSTEMDB (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.

    Restoring SYSTEMDB (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.

    Restoring SYSTEMDB (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.

    Restoring SYSTEMDB (SAP HANA Cockpit) 

    1. Review the recovery options and click Start Recovery.

    Restoring SYSTEMDB (SAP HANA Cockpit)