Sybase 12.4.2 manual Content of the backup log, 411

CHAPTER 11 Backup and Data Recovery

•On Windows NT, the server tries to place it in the following locations, in this order:

•The directory specified by the ASLOGDIR environment variable.

•The directory that holds the server executable files.

Content of the backup log

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 (Adaptive Server IQ or Adaptive Server 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 Adaptive Server Anywhere databases only)

•Method: Archive or Image

•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, with ellipses added to show continuation lines.

BACKUP, 1.0, all_types.db, ASIQ, ’1998-12-22 16:25:00.000’,.....

DBA, Full, Arch, TED_FULL00, ’’ BACKUP, 1.0, all_types.db, ASIQ, ’1998-12-22

16:53:00.000’,...

DBA, Incr, Arch, TED_X_bkup_inc, ’’ RESTORE, 1.0, all_types.db, ASIQ, ’1998-

12-22

16:25:00.000’,...

DBA, Full, Arch, TED_FULL00, ’’ RESTORE, 1.0, all_types.db, ASIQ, ’1998-12-22

16:53:00.000’,...

DBA, Incr, Arch, TED_X_bkup_inc, ’’ BACKUP, 1.0, all_types.db, ASIQ, ’1998-12-22

20:07:00.000’,...

DBA, InSF, Arch, A_partial2_yes_sf, ’’ BACKUP, 1.0, all_types.db, ASIQ, ’1998-

12-22

411