A database server can have more than one database loaded at a time. You can start databases and start the server at the same time, as follows:
dbeng11 demo sample |
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.
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 connection parameter [DBF].
Use the START DATABASE statement, or choose Start Database from the File menu in Sybase Central when you have a server selected.
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.
The -gd server option decides the permissions required to start databases.
Starting a database
Stopping a database
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |