cancel
Showing results for 
Search instead for 
Did you mean: 

SystemDB backup - Port number for connection set up and backup destination

former_member201054
Contributor
0 Kudos

Hi Experts,

I want to take systemDB backup's regularly from solution manager backup planning calendar.

I scheduled the backup for tenant DB successfully. Now would like to do the same for systemDB.

tenant DB port number is 30015..what should be the port number for systemDB..How to find it from HANA database. SQL port number is needed for defining db connection.

backup destination is already for tenantDB..should I define the backup destination for systemDB separately..

I will appreciate your help and inputs.

Thanks in advance

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member201054
Contributor
0 Kudos

Hi Dennis,

Thanks for the reply.

What about defining the backup destination for systemDB?...where should be it done specifically for SystemDB

Can it be common with tenant DB ?..

Thanks in advance

dennispadia
Active Contributor
0 Kudos

Hello Daniel,

If you are scheduling backup of HANA Database from ABAP, you just need to perform DBCO Connection for your SystemDB. In DB13, select SystemDB SID in DBA Planning Calendar > System Section, then when you click Add > under "Database Name" you will get list of all tenant and System databases.

So you don't need separate DBCO connection for each tenant, instead only one SystemDB connection is enough.

List of SQL Port used by SystemDB and all tenants can be found using below query:

SELECT * FROM SYS_DATABASES.M_SERVICES; [Execute query in SystemDB]

Also you can find port by navigating to Landscape > Services section in SystemDB (HANA Studio). Scroll to right to find out SQL Port

Regards,

Dennis Padia