SQL Server maintains several diagnostic logs including:

  • SQL Server Error Log (startup issues, database errors, login failures, backup failures, etc.)
  • SQL Server Agent Logs (job failures and scheduled task issues)
  • Window Event Logs (often contain related SQL service errors)

 

To download the SQL Server log

The SQL Server Error Log can be viewed in SQL Server Management Studio (SSMS) under Management > SQL Server Logs and can also be retrieved directly from the server’s log folder (example location: C:\Program Files\Microsoft SQL Server\MSSQL.\MSSQL\LOG\).  


To download the SQL Server Agent Log

The SQL Server Agent Log records warnings and errors related to SQL Server Agent jobs and scheduled tasks. You can view errors related to scheduled backups, maintenance plans, nightly import/exports, custom SQL jobs, and report generation jobs.

  • Open SQL Server Management Studio (SSMS)
  • Connect to the SQL Server instance
  • Expand SQL Server Agent
  • Expand Error Logs
  • Right click the log needed
  • Select View Agent Log
  • In the Log File Viewer, select Export



To download the Windows Event Viewer Application log

The Windows Event Viewer Application log records warning generated by applications running on your computer, including Sage Estimating. When an application crashes, closes unexpectedly, or encounters a runtime error, Event Viewer often contains additional details that can help support identify the cause of the problem.

To Export the Application log:

  • Press Windows + R to open the Run window
  • Type eventvwr and select OK
  • In the left pane, expand Windows Logs.
  • Select Application.
  • In the right pane, select Save All Events As…
  • Save the file to your desktop using a name such as: Application.evtx
  • If needed, compress the file into a ZIP file before submitting.


The logs can be exported and sent to support@eosgroup.com