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 .