If you want to rollback committed actions like a delete or drop by mistake you have to use point-in-time-recovery (until option) otherwise every action committed is always recovered. This is a basic feature of a database. Please have a look into the papers which describe the recovery abilities. Kind regards, Uwe
p.s. If you want the records to be there again, you have to use your data backup and reinstall the database with it. The reinstallation deletes the log volume which contains the log entries for delete operations so the delete operations are not recovered then. >-----Original Message----- >From: Christoph Weser [mailto:[EMAIL PROTECTED] >Sent: Wednesday, March 10, 2004 10:50 AM >To: maxdb (E-Mail) >Subject: AW: Backup/Restore question > >Hello Uwe! > >Well, I see, but the problem is the following: > >Before I do the Backup of the DATA and the LOG, I insert some stuff into >some tables. >So far so good. > >Right after the backup, I delete this data from the database. > >Then I do a recover......and ups.....the data which are supposed to be in >the database are still gone. > >Why they aren't restored? > >Thanx > >Chris > >-----Urspr�ngliche Nachricht----- >Von: Hahn, Uwe [mailto:[EMAIL PROTECTED] >Gesendet: Mittwoch, 10. M�rz 2004 10:42 >An: Christoph Weser; maxdb (E-Mail) >Betreff: RE: Backup/Restore question > > >Hi Christoph, > >when log is backuped it is not deleted - it may be overwritten. > >In your test the recovered data backup finds its corresponding log in the >log volume. You do not need to recover log from a log backup. > >The call of "db_restartinfo" shows you if you need a log backup to recover >or not - after you have recovered a data backup. >The recovery wizard of the dbmgui is using the same information in addition >to the file dbm.knl where all backups are logged by the kernel. > >Btw. -7015 is an information for you and means "save skipped" what means >that it is not needed. > >Kind regards >Uwe > >>-----Original Message----- >>From: Christoph Weser [mailto:[EMAIL PROTECTED] >>Sent: Wednesday, March 10, 2004 10:29 AM >>To: maxdb (E-Mail) >>Subject: Backup/Restore question >> >>Hello All! >> >>I'll do a backup of my database using following comamnds: >> >>autolog_off >>medium_put test_backup c:\test FILE DATA 0 8 YES >>medium_put test_backup_log c:\test_log FILE LOG 0 8 YES >>backup_start test_backup >>backup_start test_backup_log >>autolog_on >> >>Now I got the Complete Backup in a File called "c:\test", and the Log >maybe >>in a File called "c:\test_log.008". >> >>So far so good? <- That's a question. :-))) >> >> >>When I now want to restore data, I try the following: >> >>autolog_off >>db_admin >>util_connect >>medium_put testRestore c:\test FILE DATA 0 8 YES >>recover_start testRestore DATA >>medium_put testLog c:\test_log.008 FILE LOG >>recover_start testLog LOG 008 >> >>Here I got an error.....most time a -7075. >> >>What did I terribly wrong? Thanx in advance to all! >> >>By the way: I'm using W2K, SP4 and sapdbb 7.4.3.31. >> >>cu >> >>Chris >> >>-- >>MaxDB Discussion Mailing List >>For list archives: http://lists.mysql.com/maxdb >>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
