Backup tenant from DB13

[Former Member]

Hello,

I'm trying to schedule backups of my BI 7.4 system on DB13 but I'm getting the next error message:

It's not possible to do backups from a BI on a tenant database from DB13?

Regards

[former_member182967 · Accepted solution]

Hello Ruben,

You can also use SQL commands (then put it in crontab for automatic processing) to skip the compatibility between DBACOCKPIT and tenant DB.

#!/bin/bash

export dt=`date +%m%d%y%H%M`

/usr/sap/<SID>/HDB<nn>/exe/hdbsql -i <nn> -n <hostname>:3<nn>13 -d SystemDB -u SYSTEM -p <password> <<EOF

BACKUP DATA FOR <tenant_DB> USING FILE ('$dt')

EOF

Regards,

Ning Tong

[Former Member · Accepted solution]

Thanks Ning,

I'll try it.

But I prefer to check the backups schedule from DB13.

Thanks.

[adrian_dorn · Accepted solution]

Hello Ruben,

you can use DB13 fot tenants under SAP_BASIS 7.40 SP08 if you install the preliminary development contained in SAP note 2164096. As written in the note in the section "Procedure B", you will need to enter Blank in the field "Backup Destination". The Backup then will be made into the file specified in your backup configuration parameters.

Regards, Adrian

. 

[michael_devine]

Hi,

In SAP_BASIS 7.40 SP7 the DBACOCKPIT, DB02, DB13 scheduler does not yet support the backup of tenants. This is because when 7.40 SP7 was released, HANA did not yet have a multitenant feature. You will need to upgrade your SAP_BASIS Support Package if you want to use the DBACOCKPIT, DB02, DB13 scheduler for your multitenant DB.

There are two ways you can schedule a tenant backup with the DBACOCKPIT, DB02, DB13 scheduler (in newer Support packages):

a) Integrate the SYSTEMDB into DBACOCKPIT. Then connect to the SYSTEMDB via DBACOCKPIT. Here you can then schedule backups for both the SYSTEMDB and every tenant ==> Support Package Requirement for this alternative: 7.40 SP10 (already available for customers)

b) Connect to the tenant via DBACOCKPIT and schedule the backup for this tenant ==> Support Package Requirement for this alternative: 7.40 SP11.

Regards,

Michael Devine

[Former Member]

Hello Michael,

System has SAP Basis SP08.

Where did you find this options ti schedule the backup of tenant db?

Regards