SQL Anywhere database error : "assertion failed 101412". I
tried deleting log, rebuild database, validate database, but
all failed !! and last backup was from more than 2 months !!
Please advice.

Regards,
Ahmed A.

Ahmed A. wrote:

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

Dmitri.

If you have a backup from two months ago, you should be able to use the
active transaction log to recover this database - did you keep the
existing transaction log?

dbengX <backup_image> -a <transaction_log_file>

-chris

Ahmed A. wrote:

Thanx a lot for supporting. When I tried it, it says the
following :
Can't open transaction log file -- Can't use log file "file
name & path" since it is shorter than expected

Thank you

On Jan 27, 9:31*am, Ahmed A. wrote:
You have to do :
- copy both file .db and .log from backup in recovery folder (any
folder for security reason)
- start backup database with dbeng?.exe (? mean version 8,9...). At
this point dbeng.exe perform restore process for validating database
if it is needed.
- Some user make backup with restarting .log file. If you did it, just
translate .log file from invalid database into .sql (you have tools
for that in Sybase Central) and execute it in iSQL. If you didn't
there are option for ( I DON'T KNOW how sorry) for applying .log from
specific time. I translate .log into .sql file delete all command
from .sql before backup.....