SQL 2005 Express

Where are the SQL logs located for SQL Express ? Not the transaction logs but the logs that can be found under Managment > SQL Server Logs.
Who is Participating?
waltersnowslinarnoldConnect With a Mentor Commented:
I believe the following link can aid you..,

Guy Hengel [angelIII / a3]Billing EngineerCommented:
you should search for the ERRORLOG file, in the logs folder in the installation path
Try connecting to management studio --> New Query and execute the below query:


If you want older ones, then you can execute master..xp_readerrorlog1 or xp_readerrorlog2 and so on depending on your requirement.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.