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 Connecting to an embedded database, or DatabaseFile (DBF) connection parameter.
Use the START DATABASE statement, or choose Start Database from the File menu in Sybase Central when you have a server selected.

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 Setting a maximum page size.
The -gd server option decides the permissions required to start databases.

Start a database
Stop a database

Discuss this page in DocCommentXchange.