Using the backup directory as the transaction log directory

An alternative procedure is to use the backup directory as the transaction log directory.

Again, the figure below illustrates a database named consol.db, with a transaction log named consol.log in the same directory. For the sake of simplicity, this example assumes that the log is in the same directory as the database, although this would not generally be safe practice in a production environment. The directory is named c:\live.

The log files are held in the Live directory.
A backup command line

The following command line backs up the database using the rename and restart option, and also uses an option to rename the transaction log backup file: 

dbbackup -r -n -c "uid=DBA;pwd=sql" c:\archive

The connection string options would be different for each database.

Effects of the backup

If you back up the transaction log to a directory c:\archive using the rename and restart option and the log renaming option, the Backup utility carries out the following tasks:

  1. Renames the existing transaction log file to 971201xx.log, where xx are sequential characters ranging from AA to ZZ.
  2. Backs up the transaction log file to the backup directory, creating a backup file named 971201xx.log
  3. Starts a new transaction log, as consol.log.

After several backups, the live directory and also the archive directory contain a set of sequential transaction logs.

The Live directory and the Archive directory both contain a set of sequential transaction logs.
A Message Agent command line

You can run the Message Agent with access to these log files using the following command line:

dbremote -c "dbn=hq;..." c:\archive
Old log names different before 8.0.1

Prior to release 8.0.1 of Adaptive Server Anywhere, the old log files were named yymmdd01.log, yymmdd02.log, and so on. The name change was introduced to allow more old logs to be stored. As the Message Agent scans all the files in the specified directory, regardless of their names, the name change should not affect existing applications.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0