SAP Business One on Hana database Backup and Restore

Although in SAP Business One System Landscape Directory (SLD),  it is easy to can easily backup a company database by simply click the backup button, but in HANA Studio,  it is easier to backup and store a SAP Business One company database or even clone a company database with different name for testing.

SAP Business One on Hana database Backup and Restore

Backup:

chown ndbadm: test2/

chmod 777 test2

EXPORT “SBODEMOUS”.”*” AS BINARY INTO ‘/usr/sap/NDB/HDB00/work/test2’ WITH REPLACE THREADS 10;

tar czvf test2.tar.gz test2/

Restore:

tar xzvf test2.tar.gz

chmod -R 777 test2

chown ndbadm: -R test2

IMPORT “SBODEMOUS”.”*” AS BINARY FROM ‘/usr/sap/NDB/HDB00/work/test2’ WITH REPLACE THREADS 10;

Restore with a different database name (This is useful when need to create a test database):

tar xzvf test2.tar.gz

chmod -R 777 test2

chown ndbadm: -R test2

IMPORT “SBODEMOUS”.”*” AS BINARY FROM ‘/usr/sap/NDB/HDB00/work/test2’ WITH REPLACE RENAME SCHEMA SBODEMOUS TO SBODEMOUS_TEST;

After all, don’t forget to initial the new created company database in Administration Console center.
We will use its highly successful development methodology to deliver the right solution to meet the client’s requirements. This development methodology includes:

If you need assistance with with SAP Business One database maintenance, feel free to contact us.

If you need assistance, feel free to contact us.

Contact Us

Leave a Reply

Your email address will not be published. Required fields are marked *

12 + eight =

This site uses Akismet to reduce spam. Learn how your comment data is processed.