Re: LOG Explorer

ing.edmundo (ing.edmundo@xxxxxxxxx) writes:
Hello there... I had an intrusion into my DB and I'd like to analize
the log looking for the moment and the IP the modification was.

I would not expect to find the IP address in the transaction log. After
all, the purpose of the transaction log is make it possible to roll
transactions back or forward.

Does anyone know about free software for this?

I don't know of any free log readers, but maybe some vendors offer
evaluation copies. The two I know on the top of my head are Log Explorer
from Lumgient (www.lumgient.com) and Log PI (www.logpi.com).


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: email notificaiton when log files are getting large
    ... DECLARE @JobID BINARY ... COMMIT TRANSACTION ... Columnist, SQL Server Professional ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Transaction Isolation Level
    ... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
    (comp.databases.ms-sqlserver)
  • Re: obtaining return values from DBCC INDEXDEFRAG in a sp
    ... I didn't consider the transaction aspect of it... ... Microsoft SQL Server Storage Engine ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: SP with RETURN @@IDENTITY returning 0??
    ... Columnist, SQL Server Professional ... > SQL Server MVP ... > "Tom Moreau" wrote in message ... >> Have you tried putting the RETURN outside of the transaction? ...
    (microsoft.public.sqlserver.programming)
  • Re: How to make a SQL run longer?
    ... But hopefullly you can also access the database from a regular query ... In such case you can start a transaction that locks one of the ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (comp.databases.ms-sqlserver)