Backing Up the Data

Before selecting an approach that best fits your business requirements and backup strategy, use the SQL Anywhere documentation to learn about the various backup options

• Business requirement: – minimize the length of the time it takes to bring the SAP Mobile Platform database back online in case of a disaster.
• Backup approach: – create a recovery server to store a backup of the production databases. For each SAP Mobile Platform database that is being backed up:

• Perform a full backup
• Perform incremental backups
• Apply increments to full backups

• Enabling Transaction Log Mirroring
  (Recommended) Enable transaction log mirroring, if your backup strategy requires it. Mirror the transaction log files using the dblog command line utility to store the primary and mirror transaction logs on separate drives from the database file.
• Creating a Recovery Server
  Use a recovery server to hold all recovery data for all databases on the data tier node. Recovery data is used to recover any database on the data tier in the event of data loss or corruption.
• Performing a Full Backup after Installing or Upgrading
  Back up the entire SAP Mobile Platform runtime and data tier immediately after installing or upgrading SAP Mobile Platform.
• Performing Periodic Incremental Transaction Log Backups
  To perform an incremental backup of transaction log files, use the dbbackup command.