SAP HANA Database auto backup to FTP server daily

Mar 27, 2017 8:04:33 PM

There is nothing more important than securing your data. Although SAP HANA studio provides a way to automatically back up your database, it is best to have those backup files saved offsite.

Here we provide a way to back up your HANA database and save it to the ftp server.

The file structure is shown here:

/usr/sap/NDB/HDB00/backup/autobackup/MTC     The folder to save temporary backup data and logs files. 

/usr/sap/NDB/HDB00/backup/autobackup/MTC.sql  HANA database backup query script.

/usr/sap/NDB/HDB00/backup/autobackup/ Main script to back up automatically. 

/usr/sap/NDB/HDB00/backup/autobackup/   Script to upload tar files to ftp server.


EXPORT "MTC"."*" AS BINARY INTO '/usr/sap/NDB/HDB00/backup/autobackup/MTC' WITH REPLACE THREADS 10;

cd /usr/sap/NDB/HDB00/backup/autobackup
rm -fr MTC/*
echo "Starting backup MTC"
/usr/sap/NDB/HDB00/exe/hdbsql -u SYSTEM -p Password -i 00 -c ";" -I "/usr/sap/NDB/HDB00/backup/autobackup/MTC.sql"
tar cf "MTC-$(date '+%Y-%m-%d').tar.gz" MTC/
echo "Backup MTC Done"
rm -fr MTC/*
chmod 755 -R *.tar.gz
echo "Upload to FTP"
./ run script
echo "Done"

ftp -inv $HOST <<EOF
user $USER $PASS
cd /usr/sap/NDB/HDB00/backup/autobackup
cd /Shares/Backup/HANASERVER remote ftp folder
mput *.tar.gz

Finally create a cron job to run the daily.

crontab -e

3 22 * * * /usr/sap/NDB/HDB00/backup/autobackup/  &gt;&gt; /var/log/HanaDB-Backup.log 2&gt;&amp;1

Test: every day 9:03PM, the cron job will run, back up the database, compress the whole backup folder, and update the tar file to the ftp server.

Hope this can help.


Join Our Newsletter

See how other companies utilize SAP Business One to Improve their business efficiency.


Leave a comment

Recent Articles

Popular Articles