[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

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.
0
CaussyR
Asked:
CaussyR
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you should search for the ERRORLOG file, in the logs folder in the installation path
0
 
waltersnowslinarnoldCommented:
I believe the following link can aid you..,

http://msdn.microsoft.com/en-us/library/ms187885.aspx
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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now