Sybase IQ uses the transaction log file during recovery from a system failure. It does not use the transaction log to restore an IQ database, to recover committed IQ transactions, or to restore the Catalog Store for an Sybase IQ database. For a full restore, the transaction log must not exist. You must delete this file before starting a full restore.
Adaptive Server Anywhere databases use the transaction
log and other logs differently. If you are recovering such a database,
you need its transaction log file, and BACKUP retains
it for you. See the Adaptive Server Anywhere User's Guide for
details. Also, if you have data (other than the system tables) in
your Catalog store, transactions for that data can only be recovered
if they were written to disk before a failure.
