• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2458
  • Last Modified:

Viewing Log Files - SQL Server Express 2005

Hi Guys,
I have a SQL Sever Express 2005 database, im trying to access the log files listed under the management tree but they wont open?

 Ive tried to double clicking on the current log and the archive logs but nothing happens, how do i view the logs?

Thanks
Jay Eire
0
jay_eire
Asked:
jay_eire
  • 4
  • 3
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
are you connecting remotely? that could be an explanation.
otherwise, go in the file explorer into the LOG folder of the ms sql installation, the files are physically located there (ERRORLOG, ERRORLOG.1 etc )
0
 
jay_eireAuthor Commented:
im trying to view locally and via remote desktop in the management express studio
ive got mangament
      SQL Server Logs
            Current - 10/16/2008 11:33:00Am
            Archive 1 -
            Archive 2 -
            etc etc
can i not query the logs?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>can i not query the logs?
short answer: no, it's physical files on the disk (please see my first comment).

long answer: as the files are on the disk, you could create a linked server to the text file (as it won't move), and query that...

see here how to do that in general:
http://weblogs.sqlteam.com/phils/archive/2006/04/28/9726.aspx
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
jay_eireAuthor Commented:
is there no log file viewer? i found this link here..................
http://www.mssqltips.com/tip.asp?tip=1021
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
it should be there...
under "Management", SQL Server Logs, and double-click on any of the log file entries...
0
 
jay_eireAuthor Commented:
thats what ive done but nothing happens when i double click on any of the logs.....
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I have not yet met that problem...
what service pack?
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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