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...