Support
 
Support Get Quote
 
 
 
 

Other Resources

    How do I backup my database?


    Below are the procedures for backing up data from PostgreSQL, MySQL and MS SQL databases.
     

    Note: Before starting the backup process, stop EventLog Analyzer service.

     

    Database backup procedures for PostgreSQL (For Build#8010 and above):

    Take a backup of the existing EventLog Analyzer PostgreSQL database by creating a ZIP file of the contents available in <EventLog_Analyzer_Home>/pgsql directory and save it as pgsql_backup.zip in <EventLog_Analyzer_Home> directory.

     

    Database backup procedure for MySQL:

    Take a backup of existing EventLog Analyzer MySQL database by creating a ZIP file for the contents of  <EventLog_Analyzer_Home>/mysql directory and save it as mysql_backup.zip in <EventLog_Analyzer_Home> directory.

    Database backup procedure for MS SQL:

    Find the current location of the data and log file for the database  eventlog  by using the following commands

    use eventlog
    go
    sp_helpfile
    go

     

    Detach the database using the following commands:

    use master
    go
    sp_detach_db 'eventlog'
    go

     

    Backup the data file and log file from the current location <MSSQL_Home>/data/eventlog.mdf and <MSSQL_Home>/data/eventlog_log.LDF to the new location <New_Location>/eventlog.mdf and <New_Location>/eventlog_log.LDF.

     

    Re-attach the database and point to the old location by using the following commands

    use master
    go
    sp_attach_db 'eventlog' , '<MSSQL Home>/data/eventlog.mdf' , <MSSQL Home>/data/eventlog_log.LDF
    go

     

    EventLog Analyzer Trusted By

    Los Alamos National Bank Michigan State University
    Panasonic Comcast
    Oklahoma State University IBM
    Accenture Bank of America
    Infosys
    Ernst Young

    Customer Speaks

    • Credit Union of Denver has been using EventLog Analyzer for more than four years for our internal user activity monitoring. EventLog Analyzer provides great value as a network forensic tool and for regulatory due diligence. This product can rapidly be scaled to meet our dynamic business needs.
      Benjamin Shumaker
      Vice President of IT / ISO
      Credit Union of Denver
    • The best thing, I like about the application, is the well structured GUI and the automated reports. This is a great help for network engineers to monitor all the devices in a single dashboard. The canned reports are a clever piece of work.
      Joseph Graziano, MCSE CCA VCP
      Senior Network Engineer
      Citadel
    • EventLog Analyzer has been a good event log reporting and alerting solution for our information technology needs. It minimizes the amount of time we spent on filtering through event logs and provides almost near real-time notification of administratively defined alerts.
      Joseph E. Veretto
      Operations Review Specialist
      Office of Information System
      Florida Department of Transportation
    • Windows Event logs and device Syslogs are a real time synopsis of what is happening on a computer or network. EventLog Analyzer is an economical, functional and easy-to-utilize tool that allows me to know what is going on in the network by pushing alerts and reports, both in real time and scheduled. It is a premium software Intrusion Detection System application.
      Jim Lloyd
      Information Systems Manager
      First Mountain Bank

    Awards and Recognitions

    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    A Single Pane of Glass for Comprehensive Log Management