Manually Backing Up HANA Databases

[former_member594505]

Hello:

From time to time, I'd like to be able to (if possible) right-click on a database in the HANA Studio and back up that database, rather than using either "T-SQL" code or the System Landscape Directory to do so.

Is this possible and, if so, how?

Thanks!

John

[former_member594505]

What are Chmod commands?

John

[Abdul]

For permissions use Chmod commands to grant premission to your destination folder

[former_member594505]

Hi:

I know about the SLD and the command line. The SLD works fine. But, the command line always fails and I think that the error message mentions permissions.

That's why I was hoping that there was something through the UI.

Thanks!

John

[Abdul]

You backup individual database from SLD log in to SLD and click on database there is option export schema click on it it will back up your database..Or you can login to hana studio and use export command to back up individual database

command will be like

export "DatabseName"."*" as binary into '/mnt/dbbk-2016-12-27_2100_PRODUCTION1' with replace threads 10;

[msundararaja_perumal]

Hello,

As far I know, no option available to take individual database backup from HANA Studio UI.

You can only do instance backup, which will include all the databases from HANA Studio UI.

Apart from Remote Support Platform, you can use crontab to do backup of individual databases based on required interval.

Thanks.