How do I recover a Sybase .db file?

Classic Servoy
1

Help !!! (Please)

I have a live solution and somehow a user has found a way to delete all of one customer’s orders ! (I think my code put them in the wrong form).

I cannot get the backup to work but I do believe I have a valid database log file. I am told there is a way to recover a whole database from this.

Can someone point me in the right direction to recovering my data?

2

From a quick Google search based on “ianywhere recover log file”, here is one of several links:

http://www.sybase.com/detail?id=1010802

Dean Westover
Choices Software, Inc.

3

Thanks to you both Dean and Harjo - it is possible to restore a Sybase .db database if you have a complete (from birth) .log file

This is accomplished by going into Interactive SQL and performing Translate Log File - this creates a huge SQL statement which you then perform on an identical-but-completely-empty version of your original database file.

My challenge now is that both Sybase Central and Interactive SQL run out of Java heap space memory before they can execute the SQL file. Does anyone know how to increase the Java heap space for Sybase ? (as it runs its own Java Runtime Application aside from Windows)

I have to say that while this is causing a little difficulty at the moment, the ability to add, delete or modify ANY previous transaction in the databases’ history is a credit to the Servoy-Sybase environment and a life saver too :)

4

Still struggling here and not helped by Sybase UK much either - was told by UK Support that “…as the Account Manager for Servoy was in Holland, it was not in his (Sybase UK’s) interest to help me’” - well at least he was honest ;)
Does anyone know how to increase java heap space on Interactive SQL for Sybase?