Provides a basic backup and recovery plan.
This diagram shows the architecture for a reasonably reliable backup and recovery strategy. Only Sybase Unwired Platform components related to database recovery are included.
Sample backup and recovery plan
Shown in the diagram:
- Computer A is where the SQL Anywhere database server is installed and runs under Sybase Unwired Platform. There are three physical disks on this computer:
- The C: drive has the SQL Anywhere server and the database files (default.db, clusterdb.db, and monitor.db), which hold critical data that Sybase Unwired Platform requires to function.
- The D: and E: drives hold identical (that is, mirrored) versions of the transaction log files (default.log, and clusterdb.log). Using SQL Anywhere terminology, the D: drive holds the regular transaction log, and the E: drive holds the mirrored transaction log.
- Computer B is for long term backup, and requires only one drive (or backup tapes). Run the dbbackup utility from this computer periodically to obtain a full backup of the *.db and *.log files from Computer A.