cancel
Showing results for 
Search instead for 
Did you mean: 

Backup and restore a copy a of SAP db using Hana Studio

Former Member
0 Kudos

I attempting to backup and restore a copy of a SAP DB with a new name using HANA Studio.

I have have managed to backup successfully but restoring a copy is throwing up a couple of errors –

The following errors are showing on restore:

Could not execute 'IMPORT "DB"."*" AS BINARY FROM '/hana/backup/james' WITH REPLACE threads 10 RENAME ...' in 70 ms 380 µs .

SAP DBTech JDBC: [2]: general error: DB.ETL_S

DB:JDT1_tracking not found in the import directory.

The SQL I used as follows:

for the backup = EXPORT "DB"."*" AS BINARY INTO '/hana/backup/james' WITH REPLACE THREADS 10

for the restore = IMPORT "DB"."*" AS BINARY FROM '/hana/backup/james' WITH REPLACE THREADS 10 RENAME SCHEMA "DB" TO "DBTEST"

All suggestions appreciated!

Kind Regards,

James

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member215984
Participant
0 Kudos

Hi James,

Please check SAP Note 2114106 (Delete invalid triggers in SAP HANA if schema import fails because tracking tables cannot be found)
It requires an S-user account.
Best
former_member184146
Active Contributor
0 Kudos

Hi James ,

try this

delete the existing back up & folder and create the same folder with all rights.

use below commands

for export

EXPORT  “DB_NAME”.”*” AS BINARY  INTO  /hana/backup/james' with replace;

to import

Import "DB_Name"."*" as binary from  /hana/backup/james' with replace threads 10 rename schema "DB_Name" to "DB_Rename";

--Manish

Former Member
0 Kudos

Hi

Just as a supplement check this:

Kind regards,

Radek