Copy a database with backup and restore via command line

1064 Views

Hey folks,

I am trying to follow the steps outlined here: Copying a Database Using Backup and Recovery - SAP HANA Administration Guide - SAP Library

However, instead of using the HANA Studio to recover my 'target' system I would like to do it with the command line using the recoverSys.py script.

Here is what I have tried:

HDBSettings.sh recoverSys.py --password mySuperStrongPassword --wait --command="RECOVER DATABASE UNTIL TIMESTAMP '2099-01-01 23:59:59' using DATA PATH ('/path/to/data/backup')"

When I do this - it still looks to the backup catalog of the target system.

How can I use recoverSys.py and specify a file backup for it to use, ignoring the backup catalog? We can do it from the HANA Studio so there must be a way to do it from the command line 😊