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, we recommend that you 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 on 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 of the remote SAP HANA client . 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>
srcCrossDbName
<Source DB Name>
```
To view the product information, see Viewing and Copying CommCell Product Information.