Home Forums Article Discussions Article Discussions by Author Discuss content posted by Geoff Albin How to centralize your SQL Server Event Logs. RE: How to centralize your SQL Server Event Logs.

  • May 30, 2012 at 4:38 am

    #1494557

    Geoff A (5/30/2012)

    Hi Phil,

    Only MSSQL logs will be forwarded to the central server. That is a SQL Server Agent function.

    SQL Server Agent will not forward non SQL Application log entries.

    The modification to the script will work, but only on the server where the error occurs.

    Thanks

    Thanks for the quick reply Geoff.

    I'm having a little trouble trying to grasp the concept. Maybe I'm misunderstanding SQL Server Agent's role in this.

    I only want to monitor one SQL Server, and write the errors into a database on that server. In this case, all errors are occurring on that one server, the server that is monitoring for errors. But the script isn't picking up non-SQL specific errors. If the script is reading directly from wherever the Event Viewer Application log is, it shouldn't matter that the errors are not SQL specific?

    Thanks

    Phil