Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Maintaining Your Database » Backup and data recovery » Backing up databases involved in synchronization and replication » Managing the transaction log

 

Rename 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.

To make a repeatable incremental backup command, rename 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. The YYMMDDxx.log file names are used to distinguish between files, not for ordering.

This set of backup options is typically used for databases involved in replication. In addition to making backup copies of the database file and transaction log, the transaction log at backup time is renamed to an offline log, and a new transaction log is started with the same name as the log in use at backup time.

See also