The support utility was not able to connect to one of the configured database actions which usually indicates a connectivity problem between the host where the support utility was launched and the database server. Please try the following steps: Make sure that you have the required ODBC drivers installed. See Database ODBC Drivers for m...

KB-ID 147
Category: Self-Support Diagnosis

When using Microsoft SQL Server with EventSentry we recommend setting up a Maintenance Plan to continually check integrity reduce index fragmentation and periodically shrink the database to free up unused disk space. The following instructions assume the SQL Server Agent is running and Agent XPs is set to enabled. For instructions to enabl...

KB-ID 220
Category: Database
Applies to: All Versions

It is not currently possible to migrate data from your existing Microsoft SQL Server MySQL or Oracle database to the builtin EventSentry PostgreSQL database. You can however switch to the builtin database going forward and retain old data in the existing MSSQL/MySQL/Oracle database. To do this follow the steps below. 1. Upgrade to Even...

KB-ID 224
Category: Database
Applies to: 2.93 and later

The builtin EventSentry database ships with a basic configuration which is tuned for wide compatibility instead of speed. If you are collecting a lot of data it is likely that the default parameters are undersized for your system resulting in poor collector performance high outbound queue size or resulting in poor performance when searching...

KB-ID 232
Category: Database
Applies to: 2.93 and newer

If you are using the built in EventSentry database you can back it up using the pgdump.exe utility. This is located by default in the EventSentry\postgresql96\bin folder. You can create a batch file with the following contents: batch ECHO OFF SET PGPASSWORD=yourpostgresaccountpassword C:\Program Files x86\EventSentry\postg...

KB-ID 235
Category: Database
Applies to: 2.93+

If after purging data from your EventSentry database you still have enough disk space approximately 1.5x the database size is needed available on the drive you can open the PgADMIN software doubleclick EventSentry localhost:5432 to bring up the logon window and log on with the Postgres password and then follow these steps to shrink...

KB-ID 241
Category: Database
Applies to: 2.93 and newer

First we recommend you make a backup of the database in case you have any issues and need to reinstall: How do I back up the built in EventSentry database Once you39ve got a backup then you can proceed with moving the database by following these steps: Stop the EventSentry Database v9.6 Service Administrative Tools Services pan...

KB-ID 247
Category: Database
Applies to: 2.93 and newer