How do I read log file || SQL Logs || Text Based Log

Reading log file is a primary task for troubleshooting and finding root cause. However, it is also important to know how to read log file quickly without putting lot of efforts. Most of the busy application have big size of log file or multiple log files in a day. Hence, finding specific keyword or open big size of file could be time consuming and annoying task. however, if we know the proper technique to read the same then reading log file would be the fun. In this blog I would like to share how I read SQL error logs and any text-based log file. Read SQL Error logs: SQL Error log can be read using SSMS and T-SQL. To read SQL error log using SSMS: O pen SSMS--> SQL Server Agent--> Error Logs--> Open Log We can easily filter and search require keyword using GUI. also export the log in CSV and TXT format. The same way we can check logs for SQL Server Agent and Database Mail. also, you can load external log files as well. click on option Lo...