Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 17 » SQL Anywhere Server - Database Administration » SQL Anywhere database server executable (dbsrv17, dbeng17)

Database startup options

The database options are specified on the command line after the database file, and apply only to that database.


In this section:
    -a database option
    Applies the named transaction log.
    -ad database option
    Specifies the directories containing transaction log files to be applied to the database.
    -al database option
    Allows standard user authentication for specified users of the specified database.
    -ar database option
    Specifies that any transaction log files located in the same directory as the current transaction log should be applied to the database.
    -as database option
    Specifies that the database should continue to run after transaction logs have been applied (used in conjunction with -ad or -ar).
    -ds database option
    Specifies the directory where the dbspaces for the database and the transaction log are located.
    -dh database option
    Prevents this database from appearing when the Server Enumeration utility (dblocate) is used against this server.
    -ek database option
    Specifies the key for a strongly encrypted database.
    -m database option
    Truncates the transaction log when a checkpoint is performed.
    -n database option
    Sets the name of the database.
    -r database option
    Starts the named database as read-only.
    -ru database option
    Specifies a timestamp to restore the database to when performing point-in-time recovery.
    -ruo database option
    Specifies an offset in the transaction log to restore the database to when performing point-in-time recovery.
    -sbx database option
    Controls disk sandboxing for the database.
    -sn database option
    Provides an alternate server name for a single database running on a database server.
    -wc database option
    Controls whether checksums are enabled on write operations for the database, if it does not have checksums enabled by default.
    -xp database option
    Enable database mirroring for a high availability partner or read-only scale-out root or copy node.