SQL Anywhere Storage

By default, these databases use transaction logs. Transaction logs are stored with the database file instances in the same folder or different folders, and share the same file name but use the .log extension. Transaction log mirroring is not enabled. The default locations of these database files and transaction logs is SMP_HOME\Servers\UnwiredServer\data:

• Cache database files: default.db, default.log
• Cluster database files: clusterdb.db, clusterdb.log
• Monitoring database files: monitordb.db, monitordb.log
• Domain log database files: domainlogdb.db, domainlogdb.log

In addition, samples and tutorials use sampledb.db, sampledb.log, but backing up these database files is entirely at your discretion.

Because all of these databases make up the data tier of the platform, backup activities for this tier requires the most attention and resources. Key recommendations from SAP include:

• Storing the database file, transaction log, and the log mirror on different physical disks.
• Regularly rolling over the transaction log to minimize impact in case of storage failure.