ASA SQL User's Guide
  Working with Database Objects
    Working with databases

Starting a database without connecting

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. Right-click the desired server and choose Start Database from the popup menu.

2. In the Start Database dialog, type the desired values.

   The database appears under the server as a disconnected database.

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

1. Start Interactive SQL.

2. Execute a START DATABASE statement.

Example 

Start the database file c:\asa9\sample_2.db as sam2 on the server named sample.

START DATABASE 'c:\asa9\sample_2.db'
AS sam2
ON sample

For more information, see START DATABASE statement.