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

-ds database option

Specifies the directory where the dbspaces for the database and the transaction log are located.

dbsrv17 database-file -ds dbspace-directory ...
Applies to

All operating systems.


When a dbspace directory is specified, the database server only searches this directory for dbspaces. The location of the dbspace appears in the database server messages window.

If your backup includes dbspaces with full path names, you can use this option to start the backed up copy of the database on the same computer as the original database while the original database is still running.

The -ds database option must be specified after the database-file, and applies only to that database.

If a transaction log file is not found in the directory specified by this option, then one is created in this location.

Caution The -ds option should only be used for recovery. If you specify this option and the database has a current, live transaction log that is not located in the directory specified by the -ds option, then a new transaction log is created in the specified location.


The following example starts a database server that looks for dbspaces in the directory c:\backup\Nov15:

dbsrv17 c:\backup\Nov15\my.db -ds c:\backup\Nov15\

The following example starts a database server that looks for dbspaces in the current directory:

dbsrv17 my.db -ds .