Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2450
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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