PaulJ
2011-02-16 13:01:01 UTC
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
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