Contents Index Determining which connection has an outstanding transaction Backing up a database directly to tape

ASA Database Administration Guide
  Backup and Data Recovery
    Backup and recovery tasks

Renaming the backup copy of the transaction log during backup


By default, the backup copy of the transaction log file has the same name as the online file. For each backup operation, you must assign a different name or location for the backup copy, or you must move the backup copy before the next backup is done.

You can make a repeatable incremental backup command by renaming the backup copy of the transaction log.

To rename the backup copy of the transaction log (SQL)

To rename the backup copy of the transaction log (Command line)

Notes 

The backup copy of the transaction log is named YYMMDDxx.log, where YY is the year, MM is the month, DD is the day of the month, and xx runs from AA to ZZ, incrementing if there is more than one backup per day. There is no Year 2000 issue with the two-digit year in the YYMMDDxx.log filenames. The names are used for distinguishability only, not for ordering.


Contents Index Determining which connection has an outstanding transaction Backing up a database directly to tape