Skip to Content
avatar image
Former Member

How to restore incremental backup on different computer?

Hello,

we want to restore a MaxDB database from incremental backups on a different computer. This fails with the error below(-111,Incompatible incremental backup).

This is the scenario:

Computer A:

1. Full data backup into file backup_full.bak

2. Do some transactions

3. Incremental data backup into file backup_inc.bak

Computer B:

1. Restore with "db_activate recover" from file backup_full.bak

2. Restore with "db_activate recover" from file backup_inc.bak

=> Step two fails

Where do I do wrong? Do I need to consider the LOGs as well? I do not want to as I want to take the backup on-the-fly.

Regards,

Jens

Error:

-24988,ERR_SQL: SQL error

-111,Incompatible incremental backup

6,Data recovery failed

Servertask Info: because Error in backup task occured

Job 1 (Backup / Restore Medium Task) [executing] WaitingT271 Result=1040

Error in backup task occured, Error code 1040 "incompatible_savefile"

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 26, 2016 at 01:56 AM

    Dear Jens,

    To restore to different database, you need to use restore with initialization option to restore a full back up, then restore an incremental backup. You can use database studio to do this.

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member James Zhang

      Hi James,

      this is working fine:

      1. db_connect
      2. db_activate recover <FULL>
      3. recover_start <INCREMENTAL>
      4. db_restart
      5. db_release

      This fails:

      1. db_connect
      2. db_activate recover <full>
      3. db_restart
      4. db_release
      5. db_connect
      6. recover_start <incremental>
      7. db_release

      Regards,

      Jens