SAP HANA Restore Examples Using the HDBSQL Command Line Interface

Commvault supports the following HDBSQL restores:

A data only restore
A point-in-time restore
A secondary copy restore

To learn more about using HDBSQL with Commvault, explore the examples or code snippets.

Note

If you perform a cross-machine restore, on the destination client, set the SrcCrossClient environmental variable in the SAP HANA BACKINT parameter file to the host where you performed the backup. For information about the required and optional parameters, see SAP HANA BACKINT Configuration Parameters.

Requirements for a Cross-CommCell Restore

If you want to restore to a client computer on a different CommCell, complete the following requirements:

Set up the cross-commcell restore.

Make sure that you add the destination pseudoclient as a remote client to the source CommCell.
Add the CommCell GUID of the source CommCell to the SAP HANA param file in the destination CommCell.

You can view the source CommCell GUID in the Instance Properties dialog box of the remote SAP HANA client . For example, AFFD6890-B1A5-4B4D-A59E-F720252C9473.
1. Log on to the SAP HANA master server on the destination CommCell.
2. On the command line, go to software_installation_directory/iDataAgent/jobResults/SapHana/<dbname>.
3. To the param file, add the following parameters:
```
CvInstanceName
Instance001
CvClientName
<client name>
srcCrossClient
<source client name>
srcCrossSIDName
<source SID name>
```
To view the product information, see Viewing and Copying CommCell Product Information.