Use
the
dbbackup utility to create an incremental live backup that also resets
transaction logs on completion. Each backup uses a unique name that acts as a method of
versioning each file.
dbbackup is in SMP_HOME\Servers\SQLAnywhere12\BINXX.
On
the host of the selected runtime
database,
run:
-y – creates
the backup directory or
replaces
a previous backup file in the directory without confirmation. If you want to
be prompted, do not specify -y.
-t – create
a backup that can be used as an incremental backup since the transaction log
can be applied to the most recently backed up copy of the database
files.
-n – changes
the naming convention of the backup transaction log file
to yymmddxx.log.
xx are sequential letters ranging
from AA to ZZ.
This
indexed
file naming convention allows
you to
keep backups of multiple versions of the transaction log
file
in
the same backup directory.
-x – backs
up the existing transaction log, deletes the original log, and then starts a
new transaction log. Do not use this option if you are using database
mirroring.
For example, this command creates the incremental transaction log backup file
in the folder B:\default, in which the transaction log of
default.db (cache database) is
stored: