Stop all database activity.

Perform a successful synchronization and validate and back up the remote database.

Run the dbtran utility to display the starting offset and ending offset of the database transaction log. Make note of the ending offset.

See Log Translation utility (dbtran).

Rename the transaction log to ensure that it is not modified during the unload process. Move the renamed log file to a secure location, such as an offline directory.

Unload the database, without using any of the dbunload -a switches to automatically reload the database into another database.

See Unload utility (dbunload).

Initialize a new database.

See Initialization utility (dbinit).

Reload the data into the new database using dbisql to read the reload.sql file generated by dbunload.

See Interactive SQL utility (dbisql).

Shut down the new database.

Erase the new database's transaction log.

Run dblog on the new database, using the following options:

• Use -z to specify the ending offset that you noted earlier.
• Use -x to set the relative offset to zero.

For example:

dblog -x 0 -z 137829 database-name.db

See Transaction Log utility (dblog).

Start dbmlsync, specifying the location of the original log file that you moved earlier.

See dbmlsync syntax.

When you no longer need the old log file, set the database option delete_old_logs.

See delete_old_logs option [SQL Remote].