Configuring Database
To back up SAP MaxDB database using Veeam Plug-In, you must configure one or more backup mediums for each database that you want to protect. Also, you must configure the maximum number of backup media to allow multiple mediums to be used in parallel during a single backup operation.
To configure backup media, run the following operations:
- Enter Database Manager CLI:
/opt/sdb/programs/bin/dbmcli -uUTL -d <database> -u <login>,<password> |
where:
- <database> is a database name
- <user> is a name of the database user with administrator rights
- <password> is a password of the database user with administrator rights
For example:
/opt/sdb/programs/bin/dbmcli -uUTL -d MAXDB1 -u DBADMIN,SECRET |
- Assign the maximum number of backup mediums for backup and restore operations:
param_put -permanent MaxBackupMedia <N> |
where <N> is a maximum number of mediums that can operate in parallel during backup and restore processes.
For example:
param_put -permanent MaxBackupMedia 4 |
- To apply an updated number mediums, restart the database:
db_offline db_online |
- Assign backup mediums using the medium_put command. Veeam Plug-In requires separate backup media for each type of backups:
- Full backup (DATA)
- Incremental backup (PAGES)
- Log backup (LOG)
To learn more about the medium_put command syntax, see SAP MaxDB documentation.
For example:
In this example, the following backup mediums are assigned:
- 4 media for the full backup
- 4 media for the incremental backup
- 1 medium for the log backup
medium_put VEEAMDATA\pipe1 /tmp/MAXDB1/compipe1 PIPE DATA 0 8 NO NO / BACK |
- Optionally, you can display all assigned backup mediums using the medium_getall command:
medium_getall |