Starting a database

 Start a database on a database server without connecting (Sybase Central)
  1. Select the database server and then click File » Start Database.

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

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

 Start a database on a server without connecting (SQL)

In Interactive SQL, you must be connected to a database in order to run a START DATABASE statement.

  • Execute a 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'
    AUTOSTOP OFF;

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

 See also