Backing Up SQL Anywhere Databases

Back up platform data warehoused in SQL databases using SQL Anywhere utilities.

Prerequisites
On backup hosts, verify that SQL Anywhere software is installed, and the PATH is set. If you are running Sybase Unwired Platform as a cluster, SQL Anywhere is installed under the Sybase Unwired Platform installation directory. Otherwise, install another copy of Sybase Unwired Platform on backup machines. Otherwise, SQL Anywhere components may not work as expected.
Task
By default, Unwired Platform uses SQL Anywhere for the consolidated and cluster databases. clusterdb is present if Unwired Server has been configured to run as a cluster. Use various SQL Anywhere utilities to help you with these tasks:
  • dbvalid – validates the integrity of the database by checking the index keys on some or all of the tables in a database, as well as on the database file itself.
  • dblocate – locates any SQL Anywhere database servers (consolidated or cluster) running over TCP/IP on the immediate network, and prints a list of the database servers and their addresses. This list includes alternate server names. Depending on your network, it may take several seconds for dblocate to print its results.
  • dbbackup – makes a backup copy of all files for a single database from a remote backup location. A simple database consists of two files: the main database file and the transaction log. If you mirrored the transaction log you need not back up this file. All backup file names are identical to database file names. The image backup contains a separate file for each backed-up file.
  • dblog – mirrors the transaction log used for these databases.
Parent topic: Backing Up System Data