The Transaction Log In Backup, Restore, and Recovery

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 a Sybase IQ database. For a full restore, the transaction log must not exist. You must delete this file before starting a full restore.

Note: SQL Anywhere databases use the transaction log and other logs differently. If you are recovering a SQL Anywhere database, you need its transaction log file, and BACKUP retains it for you. See SQL Anywhere Server - Database Administration > Maintaining your database > Backup and data recovery > Types of backup. 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.

Note: This reference points to SQL Anywhere documentation.