Where to find sql server error log

Both the conditions should satisfy to return results:. Suppose we want to search SQL Server error logs for a specific duration. Suppose we want to search for keyword recovery between 7th November midnight and 9 AM. We can specify the start and end date parameter in the following format:.

In the output, you can see the result is sorted in the ascending order from the start date to the end date. We can specify parameter desc so that results are sorted in descending order from an end date to start date:. EXEC sys. Popular Articles. Rolling up multiple rows into a single row and column for SQL Server data. Ways to compare and find differences for SQL Server tables and data.

Searching and finding a string value in all columns in a SQL Server table. View all my tips. Back To Top The example in the first block of code in the article is missing a parameter. There are only 6 parameters, where in the list of parameters below that, there are supposed to be 7.

It's really good artical Users are aware of only transaction log files used for recording every transaction. However, many other log files are used such as Error Log Files that describes not just the errors but also the information related to that error.

Parameter 6: Here if we specify the time, then it will search the error log entries which are captured till this time. Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. Notify me of follow-up comments by email. Notify me of new posts by email. Parameter 3: First string you want to searh in the error log Parameter 4: Second string you want to search for to further filter the result Approach 3: Locate Sql Server Log file location using Sql Server Configuration Manager An option if you are not able to connect to Sql Server If you are not able to connect to Sql Server, then this approach will be very hand in identifying the location of the Sql Server Error Log.

Go to Sql Server Configuration Manager as shown in the below image: Alternatively, you can go to the Sql Server Configuration Manager exe location as listed in the below table and then double click on it.