68E79D4F0006| |HISTLOST |2025-10-09 13:32:31| |2025-10-09 13:32:31| | | | | | | | 0| |
68E7EC590007|DAT_000000001|SAVE WARM|2025-10-09 19:09:45|2025-10-09 19:09:45|2025-10-09 19:09:45|2025-10-09 19:13:05| 655137| |NO |VEEAMDATA | 653304| 4| 0| |
6904FD250017|PAG_000000007|SAVE COLD|2025-10-29 14:22:27|2025-10-29 14:22:27|202 5-10-31 19:17:09|2025-10-31 19:17:10| 13| |NO |VEEAMPAGES | 72| 4| -9407

Fetch information stored in the Veeam Backint for a certain database backup type:

backup_ext_ids_get <medium_name> <database>

where:

<medium_name> is the medium that you assigned during the database configuration. To understand which media are available for restore, review the backup history file.

For example, use can select the following media from the database configuration:

VEEAMDATA is a media for a full data backup
VEEAMPAGES is a media for an incremental data backup
VEEAMLOG is a media for an interactive log backup

<database> is the name of the database using which the backups were created

For example:

backup_ext_ids_get VEEAMDATA MAXDB1

Display the information from the Veeam Backint that you fetched in the previous step:

backup_ext_ids_list

This command displays information about a certain database and backup type. This information includes the following details for each backup: external backup ID, availability status, backup type and the time the backup was created.

For example:

After you collected database information, you can perform database restore.

Perform restore

To restore database, do the following:

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 for the database user has administrator rights
<password> is a password for the database user has administrator rights

For example:

/opt/sdb/programs/bin/dbmcli -uUTL -d MAXDB1 -u DBADMIN,SECRET

Switch database to the ADMIN operational state:

db_admin

Restore the database with the recover_start command:

recover_start <medium_name> <backup_type> <label> EBID <ebid_list>

where:

<medium_name> is medium that you assigned during the database configuration. To understand which media are available for restore, review the backup history file and and the output of the medium_getall command.

For example, you can select the following media:

VEEAMDATA is a media for a full data backup
VEEAMPAGES is a media for an incremental data backup
VEEAMLOG is a media for an interactive log backup

<backup_type> is the type of backup that you want to restore. To understand which backup types are available for restore, check the output of the backup_ext_ids_list command.

You can select the following backup types:

DATA is a full data backup
PAGES is an incremental data backup
LOG is an interactive log backup

<label> is an ID of a backup that you want to use. To get backup IDs, review the backup history file.
<ebid_list> is a list of external backup IDs that you want to restore. If the list contains several external backup IDs, separate them by commas. If the backup IDs contain spaces, the list must be enclosed in double quotation marks. To get external backup IDs, review the information from the Veeam Backint.

To learn more about the recover_start command, see SAP MaxDB documentation.

For example:

recover_start VEEAMDATA DATA DAT_000000001 EBID "MAXDB1 A1F7FEDCA7700BE0 /tmp/MAXDB1/compipe1,MAXDB1 6BDD1FAA716643CE /tmp/MAXDB1/compipe2,MAXDB1 7426C47F91789FCF /tmp/MAXDB1/compipe3,MAXDB1 F30423029579B4CF /tmp/MAXDB1/compipe4"