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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » Using SQL Anywhere database servers


Stopping the database server

You can stop the database server by:

  • Clicking Shut Down on the database server messages window.

  • Using the dbstop utility.

    The dbstop utility is useful in batch files, or for stopping a server on another computer. It requires a connection string in its command. See Stop Server utility (dbstop).

  • Letting it shut down automatically by default when the application disconnects.

  • Pressing Q when the database server messages window has the focus on Unix.

 Stop a database server using the dbstop utility
  1. Start a database server. For example, run the following command from the SQL Anywhere installation directory to start a server named Ottawa using the sample database:

    dbsrv12 -n Ottawa "%SQLANYSAMP12%\demo.db"
  2. Stop the server using dbstop:

    dbstop -c "Server=Ottawa;UID=DBA;PWD=sql"

Who can stop a database server?
Operating system session shutdown