How can I open a sql server log that is too big for EM? 3

[daglugub37]

Hi all,

ok I have a sql 2000 server that has experienced some memory shortage issues. I was hoping to get some info via Enterprise Manager | sql server logs...but the size is 5.5 megs and EM just hangs.

Where\how can I open the error log?

 

[mrdenny]

By default the log will be located in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\. The file is called "ERRORLOG".

If it's not in that location find the location of the files which make up the master database master.mdf and mastlog.ldf. Go up one layer and into the LOG folder.

The ERRORLOG file is simply a text file so you can open it in notepad.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ptheriault]

You should also consider cycling you error log weekly so they don't get that large. I have a scheduled job that runs
sp_cycle_errorlog every Sunday.

If you don't do that you will only get a new log everytime the SQL Service is restarted.




- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[SQLBill]

You can immediately run the sp_cycle_errorlog command, which will 'archive' the current log and open a new one. The new one will show you where the error log is being saved to, go there and open the previous error log in notepad. Make sure you uncheck the 'Always use this program'.

-SQLBill

Posting advice: FAQ481-4875

 

[daglugub37]

thanks all. Very Helpful