Using a Different Database and Log Path

Sybase recommends that you always use the default database and log path location for Unwired Platform databases. However, if you must move these files, you must ensure the servers know where to locate the system data. Otherwise, services cannot start.

By default, when you create a database in SQL Anywhere, the database and log are created in the home directory. If you change this directory, you must supply the correct information every time you restart a data service. To avoid having to supply this information repeatedly, you can use the dblog utility to set the correct filename and path.

To move a log from its default location to a new drive, use a command similar to this one:

dblog -t D:\databaseLog\default.log -m E:\databaseLog\default_mirror.log 
C:\databases\default.db

This example, moves default.log from its default location of C:\databases, to the D:\ drive, and sets up a mirrored copy on the E:\ drive. Sybase recommends naming the log files specified by -t and -m options differently.

You can use this same syntax for other databases, simply by changing the log and database file names.