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]

Reply via email to