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.

Use the SQLAnywhere dbbackup utility to perform complete database file backups. SQLAnywhere utilities are in SMP_HOME\Servers\SQLAnywhere16\BINXX.

On the host of the selected runtime database, run:

dbbackup –y –c connection-string target-directory

where:

• y – creates a backup directory, or replaces a previous backup file in the directory without confirmation. If you want to be prompted to enter a file, do not specify -y.

For example, the following command creates a full backup of the default.db database file in c:\smpbackup\full:

dbbackup -y -c "dbn=default;uid=dba;pwd=sql;links=tcpip(DoBroadcast=NO;VerifyServerName=NO;host=localhost;port=5200)" c:\smpbackup\full

• Scheduling Automatic Full Backups
  SQL Anywhere 16, which is installed with SAP Mobile Platform, provides a function for automatically backing up databases on a weekly, daily, or hourly basis.