Database auto backup

EventLog Analyzer can automatically back up its database and the databases used in the integrated products at regular intervals, as scheduled by you. Using this option, you can back up the built-in PostgreSQL DB or external PostgreSQL and MS SQL databases configured in the product.

Supported database restores

• Bundled PostgreSQL to Bundled PostgreSQL
• External PostgreSQL to External PostgreSQL
• MS SQL to MS SQL
• MySQL support has not been introduced yet

Prerequisite for backing up external PostgreSQL

1. In the machine where PostgreSQL is installed, go to <postgresql_installdir>/data and open the posgresql.conf file. Search for wal_level entry. Uncomment the entry and change its value to logical or archive.
2. Copy all the files in <postgresql_installdir>/lib and <postgresql_installdir>/bin folders, and paste them in <product_home>/pgsql/lib and <product_home>/pgsql/bin folders respectively. Create a folder named <product_home>/pgsql/data. <product_home> refers to the home directory of EventLog Analyzer or the integrated products for which you're configuring the auto backup scheduler.
3. Restart the external PostgreSQL server.
4. Repeat the steps 1 to 3 from above whenever you update the PostgreSQL server.

Steps to schedule database backup

1. Navigate to Settings → Database Settings → Database Backup.
2. Choose EventLog Analyzer or an integrated product for which you want to schedule auto backup, and click the edit icon.

3. Select whether you want to schedule the backup daily, weekly, or monthly and at what time from the Backup Frequency drop-down.

4. Enter the Backup Storage Path. You can either choose a local folder or shared folder to store the backups.
5. If the shared folder you’ve chosen needs permission to store the backups, then select the check against the Authentication Required box, and enter the necessary credentials.
6. Set a retention period for the backup files from the Maintain Backup Files drop-down.
7. Click Save.

Other settings

1. To disable auto backup for EventLog Analyzer click the icon located in the Actions column of the auto backup configuration table.
2. To get the status of the latest backup, click the icon.
3. To edit the backup schedule for a particular component, click on the icon located in the action column of the component.
4. Use the Backup Now option to initiate a backup instantly.
5. Use the Recent Backups icon in the status column to view all available backups.

Restoring backup from an old version of MS SQL server to new MS SQL server

1. If you've installed a new version of MS SQL server and want to configure it in EevntLog Analyzer in place of the old MS SQL server, you can do so by using the backup you've taken using EventLog Analyzer. Just note that, in addition to the backup you've taken using EventLog Analyzer, you need to copy the files in <MS_SQL_Old_Version>/Backup to <MS_SQL_New_Version>/backup.

MSSQL Backup

Automatic backups cannot be deleted directly from EventLog Analyzer since they are stored on the MSSQL server path. To manage backup files, adjustments must be made within the MSSQL application settings.

Troubleshooting tips

1. If you get an error while backing up the database, please check whether:
• The database server is running.
• There is sufficient space in the backup storage location.