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
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
ASKER
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?
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?
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
is there no log file viewer? i found this link here..................
http://www.mssqltips.com/tip.asp?tip=1021
http://www.mssqltips.com/tip.asp?tip=1021
it should be there...
under "Management", SQL Server Logs, and double-click on any of the log file entries...
under "Management", SQL Server Logs, and double-click on any of the log file entries...
ASKER
thats what ive done but nothing happens when i double click on any of the logs.....
I have not yet met that problem...
what service pack?
what service pack?
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 )