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: : 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!