Start the Database Manager tool with the -c1 parameter. The default path to this file is: :
- C:\Program Files (x86)\INELO\Utils\Database Manager,
- for 64-bit systems: C:\Program Files (x86)\INELO\Utils\Database Manager.
To start a file with a parameter:
- create a shortcut to the.exe file,
- go to Properties of this shortcut,
- in the Target Element field, add -c1, remembering to include a space character before the parameter (C:\Program Files\INELO\TachoScan EN\manager_db.exe -c1).
Log in to the SQL server by entering Server Name /instance_name (the path to the server can be viewed in TachoScan EN in the bottom right corner) and the password (default password is admin).
After logging in to Database Manager, select Archive and then Create a database backup. Go to the Advanced tab and select the folder where the program will create a database backup. Create two full 4TransKONFIG and 4TransMDF database backups.
The main part of database maintenance:
- Defragmenting of database.
Select Defragment In the Database tab. - Updating statistics.
After defragmentation, select the Update statistics option (this option is also located in the Database -> Defragment tab). - Shrinking .log files.
Finally, the .log files should be shrunk. Select Shrink Log File in the Database tab.
Informacja
Defragmenting, updating statistics and shrinking database log files may take a long time. Do not interrupt these operations. During database maintenance, users must not work in the program (the list of active connections to the TachoScan EN database can be checked in the Server -> Active connections menu).