As the subject leads to expect, this is probably a very stupid
question, which is likely to be answered somewhere in the
documentation or the list's archives, but I have not found it yet.

I'm currently experimenting with backup and restore procedures and
have run into a slightly confusing problem:

- I create an instance, operate on it and do a complete data backup.
- I continue to work on the instance and eventually decide that
  something has gone wrong and that I need to revert to the previous
  backup's state.
- I restore the backup and find that nothing has changed. Eh?
- I create another instance, restore the backup there and find
  myself with precisely the data I expected.

What happened? Did the database, after restoring the backup to the
original instance, automatically run the available logs to bring
the database up to the latest data?

- I turn off autolog and create another log backup medium.
- I perform some more operations on the database.
- I do a log backup, in order to purge the active log.
- I send the database into admin mode and remove the log backup
  medium, so that all log information since the original complete
  backup should be gone.
- I restore the complete backup. Again, I get the latest data, not
  what was in the backup.

What happened?

-- 
Christian Ullrich

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to