Skip to Content
Former Member
Apr 27, 2016 at 05:52 PM

Copy a database with backup and restore via command line


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 script.

Here is what I have tried: --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 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 😊