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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Running the database server » Starting and stopping databases


Starting a database

With both Sybase Central and Interactive SQL, you can start a database without connecting to it.

To start a database on a server without connecting (Sybase Central)

  1. Select the server and then choose File » Start Database.

  2. In the Start Database window, enter the required values.

    The database appears under the database server as a disconnected database.

To start a database on a server without connecting (SQL)

  • Execute a START DATABASE statement.

See START DATABASE statement.

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

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

You must be connected to a database to start another database.

The AUTOSTOP OFF prevents the database from being stopped automatically when all connections have been disconnected. It is used here to illustrate a point later on in the discussion.

For more detailed information about starting a database, see Running the database server.