locked
Write SQL Server logs to Windows Event Logs RRS feed

  • Question

  • OS: Windows 2012 Enterprise

    SQL Server: 2012 Enterprise

    Hello, 

    I was wondering if there is any way all SQL Server error log entries could be automatically written to Windows Event Log. 

    Thank you. 

    -Jeelani


    Thursday, August 6, 2015 9:46 PM

Answers

  • OS: Windows 2012 Enterprise

    SQL Server: 2012 Enterprise

    Hello, 

    I was wondering if there is any way all SQL Server error log entries could be automatically written to Windows Event Log. 

    Thank you. 

    -Jeelani



    No not all information would be written only selective are written and there is no way you can force it to do so. So specific SQL Server logs would only be written into sql server errorlog

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    Friday, August 7, 2015 3:29 AM

All replies

  • Hi Jeelani,

    I think by default SQL Logs are captured by Windows Event Log like so. 

    Hope this helps

    Thanks

    Bhanu

    Thursday, August 6, 2015 10:24 PM
  • yes sql server errors are also logged to windows event log. 

    If you want to log every activity you can enable server audit. This will log all event in to the windows log.

    If you enable server audit your server performance will degrade to a some degree. 

    Thursday, August 6, 2015 10:36 PM
  • OS: Windows 2012 Enterprise

    SQL Server: 2012 Enterprise

    Hello, 

    I was wondering if there is any way all SQL Server error log entries could be automatically written to Windows Event Log. 

    Thank you. 

    -Jeelani



    No not all information would be written only selective are written and there is no way you can force it to do so. So specific SQL Server logs would only be written into sql server errorlog

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    Friday, August 7, 2015 3:29 AM