Filter
Top Products
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