Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    Germany
    Posts
    4

    Question Unanswered: Incremental Delta Backup

    Hello,

    we have a problem with my incremental backups.

    We make a full online backup of our database on sunday.
    After full backup we perform incremental delta backups
    (3 backups a day).

    Unfortunately it happens that one delta incremental
    backup fails cause with following error code:
    SQL2426N Incremental backup is not enabled for this database. Ensure that modification tracking is activated, and perform a full backup of this
    database.

    The trackmod is activated and everything works fine a few days
    or a few incremental backups.

    Which event could make delta backups impossible?
    The only solution for this is to make a full backup and go
    on with deltas but I would like to know why this problem occurs.

    Regards,

    Oktay

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Even if you create a new tablespace, then a full database backup or atleast a backup of the new tablespace has to be done before incremental backup ...

    The error message is misleading ...

    HTH

    Cheers

    Sathyaram

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •