question

Stan avatar image
Stan asked

analyze transaction logs in SQL server 2000/2005/2008

It seems to require SQL Log Rescue or Apex SQL Log to open SQL server 2000 logs. Is there any other built-in tool or any alternative way to analyze logs?

For 2005/2008, how do you analyze logs? What kind of tool do you use? Thanks.

sql-servertransaction-log
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered

There are no built-in tools for analyzing logs. I used to own license for one of the log reading tools, but found that I almost never used it in practice. More often than not, looking at what data was changed was never as useful as looking at the queries that made the data change. Consequently I spend a lot more time looking at the cache, plan cache & trace events and have let my log tool license lapse.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.