Hi. As Yves Trudeau I am preparing myself for a possible crash. So I do a complete backup on Sunday and every other day of the week only an incremental backup. Each time an incremental backup is completed successfully I copied it into a safe place. In the documentation (pdf "Backup and recovery with the DBMCLI"), it is written (p.6) that "with incremental backups, only data that has been chenged since the last complete backup is saved. So to restore a crash, the recover's procedure should be : - recover the complete backup - recover only the last incremental backup.
Here is the test I do : - create an empty database - create tables - fill tables - do a complete backup with checkpoint - fill tables - do an incremental backup with checkpoint (A) - fill tables - do an incremental backup with checkpoint (B) - drop the database and delete files - create an empty database - set state to cold and util_execute INIT CONFIG - recover complete backup - recover second incremental backup (B) : it does not work !!! The error message I got is : dbmcli on localhost : TST>ERR -24988,ERR_SQL: sql error -111,Message not available >From the doc, a more explicit error message : "Incompatible incremental backup" [btw, why not setting this message instead of "message not available]. What did I do wrong ? Am I obliged to recover all the previous incremental backups ? Laurent _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
