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

SQL Anywhere 10.0.1 » SQL Remote » Administering SQL Remote » Transaction log and backup management » Backup utility options

Backup utility options Next Page

Using the live directory as the transaction log directory

It is recommended that you use the option to rename and restart the transaction log when backing up the consolidated database and remote database transaction logs. For the dbbackup utility, this is the -r option.

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 stored in a directory named Live.
A backup command line

The following command line backs up the database using the rename and restart option:

dbbackup -r -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, the Backup utility carries out the following tasks:

  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.

The Live directory contains 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:\live