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.
asked
analyze transaction logs in SQL server 2000/2005/2008
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.
