Hi all,

Our client has inadvertently deleted a large chunk of data, and then
discovered their backup system has not been working properly.

My thinking is to take the last backup db they have, and to apply the
current transaction log to it.

However, the application needs to stop just prior to the delete of the
data.

In see that in ASE it is possible to do this using "load tran ...
until_time ...".

Is there a way to do this in Adaptive Server Anywhere v9?

The alternative I am wondering about is to translate the current log
file. Then manually remove the delete portion, then apply the SQL file
directly to the backup db. Would this work?

Thanks for any help, would be greatly appreciated.

Paul

Hello Paul

You can translate the log file to a sql file with dbtran utility

When you have the SQL File you can remove the delete command from the
script an execute the script against a restored backup.

HTH