User's Manual

Chapter 11. Administering SQL Remote for Adaptive Server
Anywhere
1. Backs up the transaction log file, creating a backup file
c:\archive\consol.log .
2. Renames the existing transaction log file to 971201xx.log , where xx are
sequential characters ranging from AA to ZZ.
3. Starts a new transaction log, as consol.log .
After several backups, the live directory contains a set of sequential
transaction logs.
C:\Live
C:\Archive
consol.db
consol.log
consol.db
971201AA.log
971201AB.log
971201AC.log
consol.log
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:\live
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, we consider the log to be in the same directory as the database,
although this would not be generally safe practice in a production
environment. The directory is named c:\live .
251