SAP Business One on Hana database Backup and Restore

Jun 27, 2016 9:38:39 AM

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

bg-img14.jpg

Join Our Newsletter

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

 

Leave a comment

Recent Articles

Popular Articles