Informix

A bit more clarity on LEVEL 1 backups

  • 1.  A bit more clarity on LEVEL 1 backups

    Posted 3 days ago
    Hi,

    maybe a dumb question, but I just want to know for sure. In the documentation I read that a LEVEL 1 backup contains all data that has changed since the last LEVEL 0 backup.

    So this would mean that

    • I make a LEVEL 0 on Sunday
    • I make a LEVEL 1 on Monday evening
    • I make a LEVEL 1 on Tuesday evening and if successful I delete the one from Monday
    and in the Tuesday backup I have all the changed data from Monday and Tuesday.

    I did the test, and I did have the changes from both Monday and Tuesday, but I just don't have enough knowledge of informix and ontape internals to be entirely confident.

    Another reason I ask is that during testing, the LEVEL 1 archive from Monday was twice as large as the one on Tuesday (17Mb vs 9Mb).

    Thanks and best regards,
    Arjen Van Drie.

    ------------------------------
    Arjen Van Drie
    ------------------------------