Projetex Administration > Database Administration > Starting and Stopping Database Server

Firebird Database Server is a database engine which should be up and running in order for Projetex database to function. Though in some cases you may need to stop Firebird Server temporarily.

You can start/stop Firebird Database Server from the Database Server tab of the Projetex Server Administrator.

When Firebird Database Server is stopped, all database operations are not accessible. No Projetex Workstations can connect to database, and set of Projetex System Administrator features is limited by Database Server tab.

Stopping the Server

The following procedures may require stopping Firebird Server.

•

Manual backup. When Firebird Database Server is stopped, it is safe to copy projetex.fdb database file to another location by means of Windows® Explorer. Resort to this kind of backup only in cases when regular backup does not work for some reason. In all other cases regular Backup command does its job well without need to switch database into offline mode or stop Firebird Database Server.

•	Manual restore. When the server is stopped, it is safe to place projetex.fdb stopped-server backup file you have made before into its original location (C:\Program Files\AIT\Projetex 9\Projetex Server\Database\).

•	Moving current database away before running regular restore.

•	Upgrade of the Firebird Database Server software. You will be notified when this upgrade would be recommended.

Note: Stopping Firebird Database Server is a critical operation, which can result in data loss if some users are connected to the server. Always switch database into offline mode (it can be done from the Database tab of the Server Administrator) to ensure no Projetex Workstations are connected to the Database Server before running Stop Server command.

Note: It is not recommended to install newer versions of Firebird Database Server unless there is an explicit recommendation to do this from Projetex Support. We will thoroughly test all future versions of Firebird, their proper functioning with Projetex Server and Workstation software, and will consider all pros and cons before recommending upgrade. Voluntary upgrades may cause unstable operation of Projetex.