The SQL Server Error Log file is per SQL Server instance. A DBA can identify the location of the SQL Server Error Log file used by an instance of SQL Server easily.
Finding location of Windows Error logs
DBA can identify SQL Server Error Log file used by SQL Server Database Engine Using Application Event Viewer
- Click Start -> All Programs -> Administrative Tools -> Server Manager.
Finding location of SQL Server error log in Windows Error logs
- In Server Manager-> expand Diagnostics-> expand Event Viewer-> expand Windows Logs and then select Application on the left side panel. In the right panel you need to filter for events with Event ID 17111.
- The location of