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.
CaussyRAsked:
Who is Participating?
 
waltersnowslinarnoldConnect With a Mentor Commented:
I believe the following link can aid you..,

http://msdn.microsoft.com/en-us/library/ms187885.aspx
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you should search for the ERRORLOG file, in the logs folder in the installation path
0
 
geek_vjCommented:
Try connecting to management studio --> New Query and execute the below query:

master..xp_readerrorlog

If you want older ones, then you can execute master..xp_readerrorlog1 or xp_readerrorlog2 and so on depending on your requirement.
0
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.