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

SQL Anywhere 12.0.0 (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)
  • Use the MATCH keyword in the BACKUP statement. For example, the following statement makes an incremental backup of the transaction log to the directory c:\backup. The backup copy of the transaction log is called YYMMDDxx.log, where YYMMDD is the date and xx is a counter, starting from AA.

    BACKUP DATABASE
    DIRECTORY 'c:\\backup'
    TRANSACTION LOG ONLY
    TRANSACTION LOG RENAME MATCH;
 ♦  To rename the backup copy of the transaction log (command line)
  • Supply the -n option to dbbackup. For example, the following command makes an incremental backup of the sample database, renaming the backup copy of the transaction log.

    dbbackup -c "UID=DBA;PWD=sql;DBN=demo" -r -t -n c:\backup
 Notes
 See also