asa9 missing transaction log

[Former Member]

I have a db file but no log file from someone who has asked me to write a couple of infomaker reports. They can't get back to the pc where the data is held for a couple of weeks. is there anyway to get the db running ?

[MCMartin · Accepted solution]

start it with dbeng9 -f or use dblog -n to change the DB file to not use a transaction log.

[Former Member · Accepted solution]

thanks very much that got me going.

[johnsmirnios · Accepted solution]

Note that any transactions that were committed in the log that was missing will not be present in the database once you use -f. You won't be able to apply those transactions automatically via recovery either. The best you could do is translate the missing logs once you get them and execute the translated SQL statements.