Skip to Content
0
Former Member
Apr 02, 2015 at 10:30 AM

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

585 Views

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