Applying Increments to Full Backups on the Recovery Server

Update the full backup with contents of the transaction log.

Prerequisites
Use dbtran to ensure that the transaction log backup has been validated..
Task

These steps assume that the backed up files are available on the same drive as the one used by the production nodes used in the data tier node.

You can find all utilities in the <UnwiredPlatform_InstallDir>\Servers\SQLAnywhere12\BIN32 folder.

  1. Apply the incremental transaction log to the full backup by running:
    dbeng12 -o recovery.log db_name.db -a file\yymmddxx.log 
    This command updates the full backup file (db_name.db) to the current state of the transaction log backup. This is the new baseline full backup from which you can recover failed environments. To update the backup again, reapply the next increment.
    Note: Database files (for example, default.db, or clusterdb.db) are stored in a parent folder, whereas transaction logs are stored in a subfolder of the same name as the database (for example, for default.db the transaction log is output to ..\default\120616.log.
  2. Replace the db_name.db in the data directory of the restore server and restart SAP Mobile Platform data services.
  3. Verify the full backup by running:
    dbvalid -c connection-string