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)
Select the server and then choose File » Start Database.
In the Start Database window, enter the required values.
The database appears under the database server as a disconnected database.
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;
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.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|