Content of the backup log – Sybase 12.4.2 User Manual
Page 431
CHAPTER 11 Backup and Data Recovery
411
•
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