Documentation for Intellect 4.11.0-4.11.3. Documentation for other versions of Intellect is available too.

Previous page Removing the event table from the Intellect database  Restoring the Intellect database from the Suspect mode Next page


Attention!

The article provides an example of advanced settings. We recommend that you do not perform them if you do not have the appropriate qualifications, and instead contact AxxonSoft staff for help.

You cannot compress the database if the Report System is used (see The Report System).

To compress the database and reduce the size of the log files, do the following:

  1. Shut down Intellect.
  2. Launch the SQL Server Management Studio utility and connect to the server. For details, see Viewing the Intellect database.
  3. Open the Databases list.
  4. Adjust the compression settings:
    1. Right-click on the name of the database to be compressed and select Properties from the context menu.
    2. In the window that opens, go to the Options tab.
    3. Set the Recovery Model parameter to Simple.
    4. In the Automatic section, set the Auto Shrink parameter to True.
    5. Click OK.
  5. Start the compression process:
    1. For database:
      1. right-click on the name of the database;
      2. in the drop-down menu, sequentially select Tasks → Shrink → Files;
      3. in the window that opens, in the File type column, select Data;
      4. click OK.
    2. For log file:
      1. right-click on the name of the database;
      2. in the drop-down menu, sequentially select Tasks Shrink File;
      3. in the window that opens, in the File type column, select Log;
      4. click OK.

The database is now compressed.

  • No labels