Recovering Databases to Other Servers (System Copy)

In this article

    You can restore SAP HANA databases from Veeam Plug-in backups to another server. To restore databases to another server, you must reconfigure settings of Veeam Plug-in as shown below.

    For security reasons, you can restore databases to another server only in the following condition. The account you use to connect to Veeam Backup & Replication server must be the same account that performed the backup of the source system. If you want to use another account, you can assign the Veeam Backup Administrator or Veeam Restore Operator roles to the required account. For details on assigning Veeam Backup & Replication roles, see the Roles and Users section of the Veeam Backup & Replication User Guide.

    Procedure

    To restore databases to another server, you must reconfigure settings of Veeam Plug-in as shown below:

    1. Go to /opt/veeam/VeeamPluginforSAPHANA and run the following command to select the source server whose backups you want to use during restore.

    VM2ADM:/opt/veeam/VeeamPluginforSAPHANA> SapBackintConfigTool --set-restore-server

    Select source SAP HANA plug-in server to be used for system copy restore:

    1. SAP-VM1

    2. SAP-VM02

    Enter server number: 1

    1. Specify a backup repository where the required backup files are stored.

    Available backup repositories:

    1. serv10_repo

    Enter repository number: 1

     

    Note

    • The account used to connect to Veeam Backup & Replication server must have access permissions on the required repository. Otherwise the repository will not be displayed in the list of available repositories. To learn how to configure access permissions on repositories, see Setting Up User Permissions on Backup Repositories.
    • The wizard does not import existing backups from the repository. To perform a System Copy restore from the imported backup, you must map the backup. For details, see Importing Backups.
    1. Perform the SAP HANA System Copy based restore following this SAP KB article.
    1. After the restore, you must revert back the restore-server option of the Veeam Plug-in configuration wizard. Otherwise, you will not be able to restore data from the actual server backup file. If you perform only restore to other server, leave this setting enabled. It will not affect the backups of the actual system.

    VM2ADM:/opt/veeam/VeeamPluginforSAPHANA> SapBackintConfigTool --set-restore-server

    Select source SAP HANA plug-in server to be used for system copy restore:

    1. SAP-VM1

    2. SAP-VM02

    Enter server number: 2

    Available backup repositories:

    1. serv10_repo

    Enter repository number: 1

    Note

    If you are performing a system copy from another database to a database that was previously backed up by Veeam Plug-in, mind the following.
    If the catalog_backup_using_backint parameter is enabled, after performing a system copy, SAP HANA automatically starts a new log chain and sends it to the backint along with a new catalog backup. This new catalog backup overwrites the previous catalog, making it impossible to access pre-restore backups for this database.

    If you are planning to restore the older state of this database, you can disable the catalog_backup_using_backint parameter before performing the system copy.

    Also, to have access to pre-restore backups, you can store a copy of the old backup catalog outside the default directory and specify this catalog during the restore.