on 10-23-2018 6:12 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.