Skip to Content
Author's profile photo Felipe Pezo A.

Schedule backups for SAP HANA Multitenant database containers with DB13 transaction

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:

/wp-content/uploads/2016/09/17_35_59_1034352.png

        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:

/wp-content/uploads/2016/09/17_48_20_1034353.png


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

/wp-content/uploads/2016/09/17_52_29_1034354.png

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:

/wp-content/uploads/2016/09/18_06_53_1034355.png

In Database Name we can select each tenant DB available:

/wp-content/uploads/2016/09/18_08_20_1034356.png


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

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Arnold Mitre
      Arnold Mitre

      Great Article!

      Author's profile photo Felipe Pezo A.
      Felipe Pezo A.
      Blog Post Author

      Thanks Arnold 🙂

      Author's profile photo Former Member
      Former Member

      Hello,

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

      Thanks

      Author's profile photo Ashraf Hashem
      Ashraf Hashem

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

       

      Author's profile photo Willem Lourens
      Willem Lourens

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

      Author's profile photo Stefan Bobal
      Stefan Bobal

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

      Author's profile photo Sohail Rana
      Sohail Rana

      What about taking the incremental / differential backup thru DB13

       

      Regards

      Saqib Ayub Khan