There a different types of log files available when you start to install the SQL Server and manage the instance.

Whenever you talk about log file then immediate option is SQL Server error log file, which can be viewed from SQL Server Management Studio (SSMS) or as a text file from the operating system. Further the error logs are defined into SQL Server and operating system based, certain events/user-defined events/warning/errors are logged into these various log files. By default the events and information are logged with a date-time stamp. Whenever I need to view any information the simple action I follow is to open the EventViewer to open Windows Application log which provides the overall information of events that occur on the windows operating system and SQL Server services (including SQL Server Agent service). Using SSMS you can also open/view the event ...read more...