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

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 🙂

@fepezoabarca