Backup particular database on B1H HANA

[Former Member]

Hi all,

Is it possible to backup just a particular database on HANA system? We're using B1H by the way.

As my understanding currently, we could only backup and restore entire HANA environment, which mean, we backup all database on a HANA server. And, consequently, also restore the whole database on a HANA server.

If we cannot do this at current version, will it be cater on future version?

If not, SAP need to provide a way to do this, it is very troublesome if we couldn't do this.

Best Regards,

Hendry Wijaya

[duncanspeidel · Accepted solution]

HI Hendry,

You can export/backup a single HANA schema (export) by right clicking on the schema and selecting export.  You can also export a schema using the SQL Console.

export <schema name>."*" AS BINARY INTO '<path>' with replace

Example:

export SBODEMOFR."*" AS BINARY INTO '/tmp/MyBackup' with replace

You can import using:

import <schema name>."*" as binary from '<path>' with replace

Example:

import SBODEMOFR."*" as binary from '/tmp/MyBackup' with replace

At this time we do not support the renaming of a schema.  This is support as of HANA revision 61 which is not yet certified for use with SAP Business One. 

Best regards,

Duncan

[Former Member · Accepted solution]

Hi Duncan,

What a relieve reading your response. Ok, I'll check it out, thanks for your help!

[andr_macowski · Accepted solution]

Did you get success using this proposed solution?

[Former Member · Accepted solution]

Dear Duncan,

Kindly when we use this script

export <schema name>."*" AS BINARY INTO '<path>' with replace

Example:

export SBODEMOFR."*" AS BINARY INTO '/tmp/MyBackup' with replace

You can import using:

import <schema name>."*" as binary from '<path>' with replace

Example:

import SBODEMOFR."*" as binary from '/tmp/MyBackup' with replace

I can't find new schema on B1 Client database?

[duncanspeidel · Accepted solution]

Hi mohammed,

If you want to import with a new name you use the following syntax:

import "SBODEMOGB "."*" as
binary from '/home/SBODEMOGB_901' with replace threads 10 rename schema "SBODEMOGB" to
"SBODEMOGB_NEW";

The statement you used will import on top of the existing schema.  This requires revision 61 or higher.

Best regards,

Duncan

[Former Member · Accepted solution]

Dear Duncan,

you mean we need to upgrade to 61 for us to be able to backup and restore ?

but we able to make export and import but i didn't see the new schema inside B1 Client as below :

Best Regards,

Mohammad Homsi

[duncanspeidel · Accepted solution]

Hi mohammed,

You can do a backup and restore now.  You have two choices for backup:

• Right click on the SID, typically NDB, and select backup
• Follow the steps shown on http://scn.sap.com/community/downloads/blog/2013/11/08/ha-for-sap-business-one-powered-by-hana

The export steps can be used to export a single schema.  If you execute import, without rename, it will import the schema on top of the schema with the same name.

You can do a backup before revision 61.  You can do an import or an export before revision 61.  You cannot rename an exported schema before revision 61.

Best regards,

Duncan

[Former Member · Accepted solution]

Dear Duncan,

Thank you for helping but how can upgrade our hana database revision  from 60 (and how can know our hana database revision )to higher because

We need to import schema with rename and please find below our info System:

[duncanspeidel · Accepted solution]

Hi mohammed,

Which version of B1 are you running?

Best regards,

Duncan

[Former Member · Accepted solution]

Dear Duncan,

B1 9.0 HANA PL04

Thanks,

Mohammed

[duncanspeidel · Accepted solution]

Hi Mohammed,

You can download revision 69 from https://service.sap.com/sbo-swcenter > Update > SAP B1 9.0 FOR SAP HANA > SAP HANA PLATFORM EDIT. FOR B1.  You will need the following downloads:

Linux:

• HANA client 32-bit
• HANA client 64-bit
• HANA DB
• AFL

Windows:

• HANA client 32-bit
• HANA client 64-bit

Best regards,

Duncan

[Former Member · Accepted solution]

Thank you Duncan for helping

I have the following question: If we upgrade our HANA system would this affect on our current schemas inside our system?

[Former Member · Accepted solution]

Dude,

Create your own thread...

[duncanspeidel · Accepted solution]

Hi Mohammed,

Like Hendry said this should probably be its own thread,  Here is the answer to your question, please post any additional questions in a new thread.

Upgrade to revision 69 will change HANA to that version and any DB types used in your current schema would be upgraded to the revision 69 type.  The data would not change and B1 would continue to operate as designed.

Best regards,

Duncan

[former_member230865 · Accepted solution]

Hi Duncan,

Is it possible to create a schedule jobs to export specific schema or company?

If yes, can you give us an example?

Thank you.

Norman Ordanel

[duncanspeidel · Accepted solution]

Hi Norman,

Please visit http://scn.sap.com/community/business-one/blog/2013/07/24/how-do-i-use-the-cron-to-schedule-a-backup you will find the answers there.

Best regards,

Duncan

[former_member230865 · Accepted solution]

Hi Duncan,

Can you please help me how can i execute this sql command (export SBODEMOFR."*" AS BINARY INTO '/tmp/MyBackup' with replace) into cron?

Thank you,

Norman

[Former Member · Accepted solution]

Create your own thread...

[kiratheg · Accepted solution]

Hello Duncan,

I have trying to import a schema and i get this error message every time.

SAP DBTech JDBC: [2048]: column store error: table import failed:  [30151] Object not found in the import directory;object=myschemaname:DocLineTypeLayoutTempTaben

How can i possibly get to import the schema?

Regards,

George W.

[Former Member]

Hi Hendry,

I am sure SAP is working on it. Individual db backup/restore is a must for HANA. Be patient, it should be done in the near future.

Based on the note, it only said B1 backup service is not supported. Have you tried HANA backup tool directly?

Thanks,

Gordon

[Former Member]

Hi Gordon,

Yes, I agree with you, it is a must for HANA. As a matter of fact, I'm using HANA backup tool directly. Let us wait the good news from SAP for this matter. Thanks anyway.

[former_member186095]

Hi Hendry,

I think it is caused by this sap note:

1856149 - B1 DB Backup service not supported

Version 1 Validity: 07.05.2013 - active Language English

Content:    Summary |   Header Data |   References |   Validity

Symptom

SAP Business One 9.0, version for SAP HANA, does not support the traditional backup service.

Solution

Use the regular backup function of the SAP HANA database server.

Other terms

B1H; SAP Business One, version for SAP HANA 9.0; B1 9.0 for SAP HANA; SBO; B1 for HANA

Header Data

Released On	13.05.2013 02:45:16
Release Status	Released for Customer
Component	SBO-IMCE In-memory computing for SAP Business One
Priority	Recommendations/additional info
Category	FAQ

Nevertheless, you may escalate this issue to Sap Global or ask the LPE in SAP Office.

Rgds,

Jimm

[Former Member]

Yes, it is very obvious.

Still, my question is, will it be cater on future version?

I really hope someone from SAP could answer this. You just cannot adding "traditional" word to make people perceive that HANA is more advance than non-HANA. It is insulting our intelligence.

We really need the "so-called-traditional" backup method could be applied on HANA. Maybe we need to restore from backup from certain point to test particular case, maybe we need to restore other database for another case and the list of possibility could go on.

If we restore whole environment instead particular database only every-time we need to go back to certain point, it is very troublesome. Anyone with decent consulting experience could vouch for this.

[former_member186095]

Hi Hendry,

I agree with you.

Probably, the next version of SAP Hana will accommodate your requirement.

SAP note is one of SAP mouth. But if you escalate this issue to sap global support, it would be more quick rather than waiting SBO support team here.

Rgds,

JM