Backing up Data and Mirroring Transaction Logs

Mirror logs to make identical copies elsewhere on your network using SQL Anywhere utilities. Mirrored logs ensure runtime data is available and recoverable in the event of failure.

Use dblog command utility to set up log mirroring. Sybase recommends an extension of *.mlg for the mirrored log so the mirrored log can quickly be identified.

Mirror the transaction log, so that if database file becomes unrecoverable, you can use record of changes since the last backup in the transaction log to rebuild the database.

From the <UnwiredPlatform_InstallDir>\Servers\SQLAnywhere11\BIN32 directory run the dblog command with the -m option: For example, to mirror the original log file on drive D:\ to drive E:\ use:

dblog -t D:\logs\default.log -m E:\logs\default_mirror.mlg default.db