Skip to Content
avatar image
Former Member

Maxdb incremental backup too large- impossible to be done

Hello

We have a ~2Tbytes Data Base MaxDB 7.9 that daily from Monday to Thursday is done a incremental backup to disk.

The usual incremental backup presents a 1.5 GB of data in disk.

This week we are experiencing a unusual behaviour that is a huge increase in the size of the incremental backup.

We have tried and the last incremental backup that we have tried and failed was 168 GB  which is 100 times greater than the usual and even this was not complete with success.

In the DB there is no error besides the error of space unavailable to perform the incremental backup.

The last week Friday night the Full Backup has run with success.

Does anyone have an idea what is the cause of this behaviour and how can we previously with any command knew the dimension of the incremental backup ?

Thanks

Best Regards

Sílvia


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 25, 2016 at 10:36 AM

    Hmm, please note that a MaxDB incremental backup always saves all pages changed since the last full backup. So over time each following incremental backup should be larger than the previous one if no complete backup was performed.


    But of course 168 GB instead of 1,5 GB is a drastic increase. Have you checked the database size (used area)? You should see this via the Database Analyzer in the Expert View 'DB_Filling', maybe the used area has grown as well?

    Thorsten

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Thorsten Zielke

      Hi

      I've been talking with our development colegues and they haven't done no changes in the structure of the MAXDB database.

      Thanks

      Best Regards

      Sílvia