Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » SQL Anywhere database servers » Starting and stopping databases


Starting a database without connecting (SQL)

You can start a database without connecting to it by using the START DATABASE statement.


By default, you must have the SERVER OPERATOR system privilege. The required privileges can be changed by using the -gd database server option.

  1. Connect to another database.

  2. Execute a START DATABASE statement.


The database is started.


Start the database file c:\temp\temp.db on the current database server.

START DATABASE 'c:\\temp\\temp.db'
AS tempdb 

The AUTOSTOP OFF connection parameter prevents the database from being stopped automatically when all connections have been disconnected.

 See also