SAP MaxDB Backups

The Commvault software supports the following backups:

Full
Incremental
Selective Online Full
Archive log
Automatic archive log

Use one of the following options to automate SAP MaxDB backups that use the Commvault software:

Use the SAP DBMGUI interface
Create a script that has a sequence of commands, and then run the script

You can use a schedule policy to perform the backup. For more information about the schedule policies, see Schedule Policies Overview. The schedule policy automatically changes the database state to the offline (cold) state or the online (warm) state based on the backup type you selected. However, you must complete the following steps to allow the schedule policy to perform the backup:

Update the access information in the properties of the SAP MaxDB instance.

For more information, see Creating a SAP MaxDB Instance.
Install and deploy the SAP MaxDB workflow.

For instructions about how to install the workflow, see Downloading and Updating Workflows from the Commvault Store.

For instructions about how to deploy the workflow, see Deploying a Workflow.

Note

You must consider running full backups and log backups for SAP MaxDB one after the other because backint configurations files cannot be reused until the existing job completes.

User Permissions

The user performing the backup and restore operations must have a minimum of the following DBM permissions:

SERVERRIGHTS= Backup, Recovery, Scheduling, DBInfoRead, DBStop, DBStart

Examples

To create a user who does the backup and restore operations for MaXDB, use the following command:
```
dbmcli -d cert1 -u dbm,dbm
dbmcli on cert1>user_create CVLTUSER,COMMVAULT
```

To assign the permission, use the following command:

 
dbmcli on db1>user_put <username> SERVERRIGHTS=+Backup,+Recovery,+DBInfoRead,+Scheduling,+DBStop,+DBStart

To verify the permissions assigned to the user, use the following command:
```
 
dbmcli on db1>user_get backup_user
```