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

Previous page Removing the events from the PROTOCOL table using SQL queries  Compressing the database size Next page


If necessary, you can clear the table with events from the INTELLECT database. For example, if the database has become very large.

Attention!

Once you remove the event table, it cannot be undone. We recommend you to create a backup before removal (see Creating the database backup copy).

To remove the events table from the Intellect database, do the following:

  1. Shut down Intellect on the server where the database to be cleared is stored.
  2. Launch the SQL Server Management Studio utility and connect to the server. For details, see Viewing the Intellect database.
  3. Go to the folder with tables Databases/intellect/Tables.
  4. Delete the PROTOCOL table.
  5. Quit SQL Server Management Studio.
  6. Run the idb.exe utility (Start -> Programs -> Intellect -> Update database).
  7. Click the Update database button in the utility and wait for the message about the completion of the update (see Interface elements of the idb.exe window).
  8. Close the idb.exe utility with the OK button.

As a result, the event table will be deleted.

  • No labels