# Performing a SAP MaxDB Incremental Backup

An incremental backup contains only data that is new or has changed since the last backup, regardless of the type. On average, incremental backups consume far less media and place less of a burden on resources than full backups. To streamline the backup process and to optimize the time and resources, you can run incremental backups.

## Procedure

### Offline (Cold)

1. Open the DBM command line interface and verify the status of the database.

       #> dbmcli -d $[CERT1] -u $[dbm,dbm] -uUTL
        dbmcli on CERT1>db_state
       OK
       State
       ADMIN

2. Create a table and add records.

   Usage example:

       #> sdbfill $[dbname] $[init|create|append|check|delete] [$[From] $[To]
       [$[TransactionLength]  [$[SleepBeforeCommit]  $[q|a|b]
       [$[dba dbapassword]]]]]]

       #> sdbfill $[CERT1] $[append] $[1000000 2000000 10000 0] a DBA DBA
       2000000, finale commit at 1999999
       1000000 rows inserted successfully.

3. The SAP MaxDB database must be in the admin (cold) state. If the database is not in this mode, type the following command.

       #> dbmcli -d $[CERT1] -u $[dbm,dbm] db_cold

4. Type the following command to execute the offline incremental backup.

       #> dbmcli -d $[DBSID] -u $[dbm,dbm] -uUTL -c backup_start BackPages migration

5. A return code of 0 means the backup was successful.

       ok
        Return Code 0

### Online (Warm)

1. Open the DBM command line interface and verify the status of the database. Type the following command:

       #> dbmcli -d $[CERT1] -u $[dbm,dbm] -uUTL
        dbmcli on CERT1>db_state
        OK
        State
        ONLINE

2. The SAP MaxDB database must be in the online (warm) state. If the database is not in this mode, type the following command.

       #> dbmcli -d $[DBsid] -u $[dbm,dbm] db_warm

3. Type the command to run the online incremental backup.

       # dbmcli -d $[CERT1] -u $[dbm,dbm] -uUTL -c backup_start BackPages2 Recovery

4. A return code of 0 means the backup was successful.

       ok
        Return Code 0

×

Loading...