Viewing the Windows Application Log
Each SQL Server session writes new events to the Windows Application log. Unlike the SQL Server error log, a new Application log is not created each time you start an instance of SQL Server.
View and manage the Application log by using Event Viewer or the Log Viewer in SQL Server Management Studio.
There are three logs that can be viewed with Event Viewer.
Windows log type
Records events logged by the Windows operating system components. For example, the failure of a driver or other system component to load during startup is recorded in the System log.
Records security events, such as failed login attempts. This helps track changes to the security system and identify possible breaches to security. For example, attempts to log on to the system may be recorded in the Security log, depending on the configured audit settings.
Only members of the sysadmin fixed server role can view the Security log.
Records events that are logged by applications. For example, a database application might record a file error in the Application log.
For more information about using Event Viewer, managing the Application log, and understanding the information it presents, see the Windows documentation.
For more information, see How to: View the Windows Application Log (Windows)