Starting and stopping databases

A database server can have more than one database loaded at a time. You can start databases and start the database server at the same time, as follows:

dbeng12 demo sample

Caution

The database file must be on the same computer as the database server. Managing a database file that is located on a network drive can lead to file corruption.

Starting a database on a running server

You can also start databases after starting a server in one of the following ways:

Connect to a database using a DatabaseFile (DBF) connection parameter while connected to a server. The DatabaseFile (DBF) connection parameter specifies a database file for a new connection. The database file is started on the current server.

See Embedded database connections, or DatabaseFile (DBF) connection parameter.
Use the START DATABASE statement.
In Sybase Central, select a server, and then click File » Start Database.

See START DATABASE statement.

Limitations

The server holds database information in memory using pages of a fixed size. Once a server has been started, you cannot start a database that has a larger page size than the server.

See Maximum page size considerations.
The -gd server option decides the permissions required to start databases.

Starting a database
Stop a database

Discuss this page in DocCommentXchange.