For every backup or restore you perform, the backup log contains the following fields, separated by commas:
Operation (Backup or Restore)
Version
Database name
Database type (Sybase IQ or SQL Anywhere)
Date and time of backup or restore
Creator user ID
Type of backup/restore: Full, Incremental, or Incremental_since_full, or Database File Only (for SQL Anywhere databases only)
Method: Archive (for IQ or Anywhere databases) or Image (Anywhere databases only)
Location
Comment (if entered on the BACKUP command), enclosed in single quotes. If the comment includes quotes, they appear as two consecutive single quotes.
Here is a sample backup log.
BACKUP, 2.0, all_types.db, ASIQ, '2009-01-31 16:25:00.000', DBA, Full, Arch, TED_FULL00, ''
BACKUP, 2.0, all_types.db, ASIQ, '2009-01-31 16:53:00.000', DBA, Incr, Arch, TED_X_bkup_inc, ''
RESTORE, 2.0, all_types.db, ASIQ, '2009-01-31 16:25:00.000', DBA, Full, Arch, TED_FULL00, ''
RESTORE, 2.0, all_types.db, ASIQ, '2009-01-31 16:53:00.000', DBA, Incr, Arch, TED_X_bkup_inc, ''
BACKUP, 2.0, all_types.db, ASIQ, '2009-01-31 20:07:00.000', DBA, InSF, Arch, A_partial2_yes_sf, ''
BACKUP, 2.0, all_types.db, ASIQ, '2009-01-31 20:07:00.000', DBA, InSF, Arch, A_partial2_yes_sf, ''
