export SQL Server Log 1

[mikej28621]

SQL server 2000. I have a log file that has grown to 55 MB. I tried to get into it but it sits there and counts up memory 300 bytes at a time. I was hoping to find what caused it to grow. I had to end the enterprise manager because it was taking up 100 percent of the process.

Any thought about how to get into it, export it or import it into something else.

Thanks

MJ

 

[JayKusch]

You cannot "get into" the Tlog w/out a third party utility like Lumigent Log Explorer. What exactly are you trying to accomplish?

Thanks

J. Kusch

 

[JayKusch]

By the way ... the TLog grows due to actions performed in the database that the TLog belongs to.

Thanks

J. Kusch

 

[SQLBill]

I have a log file that has grown to 55 MB

What kind of log file are you talking about?

There's the SQL Server Error Logs,
the SQL Server database Transaction Logs,
the Windows Event Logs


-SQLBill

 

[mikej28621]

quite right.. Sorry about that I should have said the SQL Server error log under Mangement in Enterprise Manager.

I just want to be able to read it.

Thanks

MJ

 

[SQLBill]

Run this:

EXEC SP_CYCLE_ERRORLOG

That command will close the current log and start a new one. Then you can view the old one.

-SQLBill

 

[mikej28621]

SQLBill, thanks for that command. I will use it next time.

I rebooted to get a new error log and it still won't let me in the offending big log (I can get into any other one). It starts counting up memeory in the task manager, processor spikes to 100 percent and it just sits there. I have waited for 5 to 10 minutes.

Hope that helps

MJ

 

[Corran007]

You can open the log file outside of sqlserver. its located in the log folder under your instance name. just select the one you want and open it with notepad or another text reader. however being a 55mb text file, id do it on a non production machine that has alot of memory.

 

[mikej28621]

Thanks Corran007, I found it and was able to retrieve the file.

MJ