Schedule backups for SAP HANA Multitenant database containers with DB13 transaction

[Former Member]

In the following post you can find a how to for schedule backups through DB13 transaction for a SAP HANA Multiple container system.

Contents

• Prerequisites
• How to schedule backup using transaction DB13
• More Information

Prerequisites

Through transaction DB13 we can support the backup of SAP HANA multiple-container systems, but only as of the following SAP_BASIS Support Packages:

• 7.40 SP10
• 7.31 SP15
• 7.30 SP13
• 7.02 SP17

For this how-to document, we are working with a SAP NW 7.40 SP15 on SAP HANA SPS11

How to schedule backup using transaction DB13

To schedule backups for a SAP HANA multiple-containers system, first we need integrate SYSTEMDB into DBACOCKPIT:

1. In transaction DBACOCKPIT create a database connection like the following:

        Important: The SL port to be used for the DB connection is entered en the following form:

• 3<SAP_HANA_instance_number><two-digit number>
  • 3xx15 is for a SAP HANA Single-container system
  • 3xx13 is for a SAP HANA multiple database container, the SQL port numbers increment for each tenant database starting from 41, for example: 3xx41, 3xx44, 3xx47, 3xx50, etc.
• To identified the SQL port you can execute the following SQL query:
  • SELECT DISTINCT(sql_port) FROM SYS.M_SERVICES WHERE SQL_PORT > 0
  • Example:

2. After create the database connection, in transaction DBACOCKPIT we can find our SYSTEMDB:

Important: To see the SAP HANA multitenant database containers menu it's necesary set the SYSTEMDB like default system (See the image above).

3. Now, we can use the transaction DB13 to schedule backups for each tenant database in our SAP HANA multiple-container system:

In Database Name we can select each tenant DB available:

More Information

For know more about this topic, see the following SAP Note: 2164096 - Schedule backups for SAP HANA multiple-container systems with DB13

Best regards from Chile :smile:

@fepezoabarca

[arnoldmitre]

Great Article!

[Former Member]

Thanks Arnold :smile:

[Former Member]

Hello,

Can you also preconfigure a task for deletion of old backups in DB13?

Thanks

[former_member574030]

nice blog worked for me s4hana 1709 on hana 2 sp 2

 

[Former Member]

Thanks!  The tenant database can be backed up every night, but how often should the system database be backed up?

[former_member402287]

This is what I'm looking for also. Have you find out this please? Thank you.

[sohail_rana]

What about taking the incremental / differential backup thru DB13

 

Regards

Saqib Ayub Khan