EventReport - What happens to event logs if Database fails?

Support, Questions and Discussions on EventReporter

Moderator: alorbach

Google Ads


EventReport - What happens to event logs if Database fails?

Postby ckflentje » Tue Apr 14, 2009 10:09 pm

If EventReporter is setup to write Windows Event logs to a database ("Write to Database") and the connection to the database drops, or EventReporter fails to connect to the database, what happens to the Windows Event logs that occur during the failure? Is EventReporter "smart" enough to continue logging the events where the failure occurred once the connection is re-established?

How about if the database is down for several hours or days? When the database finally comes back online, will EventReporter be able to write all the Windows Event messages that occurred while the database was down?

Thanks,
ckflentje
ckflentje
New
 
Posts: 2
Joined: Tue Apr 14, 2009 10:00 pm

Re: EventReport - What happens to event logs if Database fails?

Postby alorbach » Wed Apr 15, 2009 8:38 am

Hi ckflentje,

the EventLog Monitor is a serialized service inside EventReporter which means it will only continue to process Events if the Actions (Like Database Logging) were successful. In case of a failure, EventReporter will log an error event with ID 114 into the application EventLog. EventReporter will retry to process the same Evenet during it's next iteration and once the Database Logging recovers, it will report another event with ID 114 and continue it's work.

--
I hope this helps - best regards,
Andre Lorbach
alorbach
Site Admin
 
Posts: 1627
Joined: Thu Feb 13, 2003 11:55 am

Re: EventReport - What happens to event logs if Database fails?

Postby ckflentje » Wed Apr 15, 2009 1:49 pm

That was a quick response - thanks! We own an old version of EventReporter and are looking to use the latest version for a new project but wanted to be sure of its "recoverability" before we upgraded. As long as we can ensure EventReporter can recover up to a days worth or more of Window Events that didn't get logged (due to db failure/down time) we'll probably proceed forward with the project.

Thanks again,
ckflentje
ckflentje
New
 
Posts: 2
Joined: Tue Apr 14, 2009 10:00 pm

Re: EventReport - What happens to event logs if Database fails?

Postby alorbach » Wed Apr 15, 2009 3:06 pm

The only thing that can happen is, that the EventLog runs full after some time, and older events get overwritten. But you will find some advanced options on the "Advanced EventLog handling" tab (configureable for each EventLog Channel) for even for those conditions.

I recommend to download the latest trial version of EventReporter, and perform some tests. If you need more trialtime, just drop a little email to support@adiscon.com, and we will see what we can do ;).

--
best regards,
Andre Lorbach
alorbach
Site Admin
 
Posts: 1627
Joined: Thu Feb 13, 2003 11:55 am

Google Ads



Return to EventReporter

Who is online

Users browsing this forum: No registered users and 0 guests

cron