Add database

Access

Organizer > Top navigation > System > Database > Add database

General Information

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

You can use this function to copy, to move or the update a SQL server database.

Requirement

  • First the database has to be disconnected. If you try to add a database that has not been disconnected, an error is returned.
  • If you add a database, all data files (MDF- and LDF-Files) must be available. If a data file has another path in contrast to creating or adding the database, you must define the current path of the file then.

Functions

Database name

Restore locally A local path on the computer can be selected for the database
on the server by the net

An SQL server database can only be carried out on a local path.

This means that when carrying out the backup command from a client, the local save path of the server needs to be transferred. This is why there is no dialog box to select the path.

Database name The name is automatically taken from the selected BAK-File, but can be subsequently customized.
Location of the database (MDF) Path specification for the location of the *.MDF file.
Location of the log file (LDF) Path specification for the location of the *.LDF file.