cancel
Showing results for 
Search instead for 
Did you mean: 

Restoring Sap Hana cloud instance using a database backup file

Dipnesh
Explorer
0 Kudos
273

Hello experts 

i have a backup file of  a database of a particular SAP BTP trial account now  i wants to restore this database over Sap Hana cloud instance in a new SAP BTP trial account .

i have explored Sap community to find solution and guidance .

in that journey i got some articles and tutorials.

 

 1.)  https://community.sap.com/t5/technology-blogs-by-sap/clone-sap-hana-database-instance-via-template-b...

This tutorial help us to clone SAP HANA database instance via template based cloning.

but this guidance only helps me to clone SAP HANA database instance  within same trial account .

2.)  https://community.sap.com/t5/technology-q-a/hana-database-explorer-import-catalog-objects-in-hdi-con...

This guidance material helps me to import catalog objects in HDI container.

again ,this solution is limited within single trial account because we can only import and export SAP  HDI(Hana deployment infrastructure) Container for copy purposes within single trial account.

Both tutorial covers cloning Hana cloud instance and importing and exporting HDI container  but both are limited within single SAP BTP trial account and i wants to restore Database over sap Hana cloud instance using database back up file of different trial account.

 

@thomas_jung @qmacro , @MioYasutake ,@gregorw, please help me How to restore database over SAP HANA cloud instance using backup file of a database.

 

 

RobertWaywell
Product and Topic Expert
Product and Topic Expert
0 Kudos
How did you create your database backup from the trial HANA instance?  Backup and restore of SAP HANA Cloud instances is fully managed by SAP HANA Cloud. There is no option for creating an external backup.
AlexPJ
Explorer
0 Kudos

SAP HANA Cloud recovery to another instance is on the roadmap for Q4/2024:
https://roadmaps.sap.com/board?PRODUCT=73554900100800002881&range=CURRENT-LAST#;INNO=000D3ABE772D1EE...
I have no idea whether this will be supported with a Trial Account. 
You may want to have a look into the HDI Container Export/Import functionality (though I do not know whether this works in a Trial Account):
Export/Import an SAP HDI Container for Copy Purpos... - SAP Community

View Entire Topic
Dipnesh
Explorer
0 Kudos

Thanks @AlexPJ  @RobertWaywell  for your reply , i have followed this article for exporting Hana HDI container for copy purposes 

 https://help.sap.com/docs/SAP_HANA_PLATFORM/3823b0f33420468ba5f1cf7f59bd6bd9/36a5547af0304ee29e964ab....

 

CREATE COLUMN TABLE <MySchema>.EXPORT_TABLE LIKE _SYS_DI.TT_CONTAINER_EXPORT;
GRANT INSERT, SELECT ON <MySchema>.EXPORT_TABLE TO C1#DI;
CALL _SYS_DI#G.EXPORT_CONTAINER_FOR_COPY
('C1', <MySchema>, 'EXPORT_TABLE', _SYS_DI.T_NO_PARAMETERS, ?, ?, ?);
EXPORT <MySchema>.EXPORT_TABLE AS BINARY INTO '<export_path>'
WITH REPLACE NO DEPENDENCIES;

as per article ,this SQL code exports HDI container. I am using using sap BTP trail account  ,in this environment what should be value of  '<export_path>' .                                                                                                              

Dipnesh_0-1728474251727.png

@thomas_jung @qmacro , @MioYasutake ,@gregorw,

AlexPJ
Explorer
0 Kudos

You followed documentation that is for HANA Platform, i.e. for HANA on-premise instances. This won't work with HANA Cloud. 
Use the documentation for HANA Cloud, HANA databases instead, for instance Importing and Exporting with Amazon Web Services | SAP Help Portal or Export an SAP HDI Container for Copy Purposes to a Cloud Store