To move an existing MSSQL database to a different server simply detach the database from the existing server copy it to the new system and reattach it. After the DB is online simply initialize the database again and update all connection strings: 1. Stop all EventSentry services. If you are not using the collector then all remote agents sho...
This guide shows how to restore an EventSentry .backup file created with pgdump see KB235https://www.eventsentry.com/kb/235howdoibackupthebuiltineventsentrydatabase onto a separate dedicated PostgreSQL server for example to access archived/historical data without risking disk space or performance issues on your producti...
EventSentry Database Rotation: Creating a New Database ampamp Archiving the Old As an EventSentry database grows managing longterm data retention while maintaining performance becomes critical. While you can purge old records some environments require a Database Rotation. This process involves initializing a fresh Primary database for ...
This article explains how to run a custom database query on a schedule write the results to a log file and surface that data in EventSentry39s Web Reports. The setup uses a Windows System DSN to connect to a database which means it works with any ODBCsupported engine including SQL Server PostgreSQL MySQL and others. The steps below use P...
The Archive feature in EventSentry enables continuous parallel synchronization between a primary and secondary database. Once activated both databases remain active: one handles live data while the other serves as a realtime archive. Archiving is not retroactive the archive database will only store data collected from the moment the featur...
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 v14 Service Control Panel Administrative Tools ...
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...
If you experience data corruption data loss or accidentally delete files from the internal Postgres database this guide will walk you through the steps to regenerate the internal Postgres database structure and recreate a fresh empty EventSentry database. Before proceeding with this guide ensure that you back up the data14 directory. T...
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...
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\postgresql14\bin folder. You can create a batch file with the following contents: batch ECHO OFF SET PGPASSWORD=yourpostgresaccountpassword C:\Program Files\EventSentry\postgresql14\bin\p...
The anticipated database size depends on many factors not just the number of hosts that are being monitored. In order to predict the future database size you will need the following information: How many servers will be monitored What event log data will be consolidated For example will you be collecting Audit Success events How many...
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 enable ...
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 EventSen...
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 more ...