2

I'd like to know whether there is any way of browsing/searching the SQL Server transaction logs (any version).
We've previously used tools such as Lumigent Log Explorer against SQL Server 2000 which fulfilled our need, but the product no longer exists and Lumigent's closest replacement doesn't appear to support SQL 2008 (according to the data sheet).

I've discovered something called ApexSQL Audit which may fit the bill, but I'm wondering if anyone has any experience of it, how it compares with Log Explorer, and whether there are any good alternatives out there.

Desperatuss0ccus
  • 252
  • 1
  • 4
  • 9
MartW
  • 1,305
  • 10
  • 15
  • If you don't need a tool, have a look here http://www.databasejournal.com/features/mssql/article.php/1443371/Viewing-the-Transaction-Log.htm – Peter Schuetze Feb 12 '10 at 17:22
  • The question popped up again in the queue and was locked, I edited it a bit to see if it can be reopened as I think it might still be useful to update. If you disagree with my edits @martW, feel free to rollback. – Reaces Oct 09 '15 at 08:42

3 Answers3

2

I think you mean Apex SQL Log. Apex SQL Audit builds auditing into a database. You can download Apex SQL Log for a free, full-featured trial.

K. Brian Kelley
  • 9,034
  • 32
  • 33
1

i believe Quest's Litespeed comes with a transaction log reader.

http://www.quest.com/litespeed-for-sql-server/

SQLRockstar
  • 713
  • 6
  • 10
0

If you need a SQL log file viewer then you can go with SysTools SQL Log Analyzer. This is an excellent tool for analyzing transaction logs of a log file and also you can use this tool for forensics purposes.

Lj Burrows
  • 1