Backup Log

SAP Sybase IQ logs events that occur during backups and restores to .backup.syb.

There is only one backup log on a server. The server must be able to read and write this file. The system administrator may want to limit access to this file by other users.

Location

Location of the backup log depends on the setting of environment variables at server startup time. If you are running more than one database server on a system, set the $IQLOGDIR16 or %IQLOGDIR16% environment variable differently for each server to produce separate backup logs.

Backup Log Location
Platform	Location
UNIX-like operating systems	The server tries to write backup.syb to one of the following locations, in this order: Directory specified by the `$IQLOGDIR16` environment variable Directory specified by the `$HOME` environment variable Home directory as obtained from account information `current directory` (where the server was started) The server writes .backup.syb to the `$HOME` directory as a hidden file, and the file name is prefixed with a ".". If the server writes the file to the `current directory`, backup.syb is not hidden and not prefixed.
Windows	The server tries to write backup.syb to one of the following locations in this order: Directory specified by the `%IQLOGDIR16%` environment variable Directory that holds the server executable files.

Sample Output

The backup log contains a comma-delimited list of events that occurred during backups and restores:

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, ''

Maintenance

After you purge backup media, use a text editor to clean up the backup log after you purge backup media. Do not edit the backup log while a backup or restore operation is in progress. Be careful with your edits: once BACKUP DATABASE or RESTORE DATABASE writes to the backup log, it does not check its accuracy.

Note: To display only the information about a particular backup, you can run RESTORE DATABASE with the CATALOG ONLY option. This option displays the header file for a backup from the media rather than from the file, so that the DBA can identify what is on the tape or file.