Datenbank

Access

Organizer > Top navigation > System > Database

General Information

The database overview provides an overview of all of the databases on the server, and this is where they are managed - i.e. it is where they can be saved, separated or restored.

Functions

Backup database After calling up the function in the top toolbar, a new dialog box appears for saving the database. The path where the file is to be saved is entered here.
Recover database

The function Restore database is used to restore database backups. This means that a BAK file needs to be selected.

Files of the types MDF or LDF cannot be restored!

Separate database The currently highlighted database is disconnected from the server; the MDF and LDF files remain. This is necessary e.g. if the database is to be coped; the MDF file cannot be copied when the database is connected.
Add database

A database type MDF can be connected to the server. It is then possible to access this database from imos .

Refer for that the chapter Add database.

Maintenance schedule

Selecting this function opens a new dialog box where the maintenance schedule may be defined.

For further information read Maintenance schedule.

Database defragmentation

The current registered database can be defragmented over this.

Defragmenting the database optimizes the database with regard to your performance.

Before the defragmentation starts, a backup of the database is performed. Please, ensure that nobody else is registered on the database. After a successful defragmentation it is necessary to restart and afterwards to check the database.

Create PlanLink data base* Creates a data set that includes the Plan Link database.
Create NET database* Creates a data set that includes the NET database.

*) This function is optional and is not included in the basic version of Organizer .