how to explore/ retrieve SQL Server Transaction Log information

  • Can anyone advise me on how to explore/ retrieve SQL Server Transaction Log information e.g. interprete record of table/ row update/ delete command, including the information of host computers and user IDs, timestamps etc.?

    Or, Can anyone help me quoting any effective software that can do this on any previous transaction?

    Or, Can anyone advise me whether "eVisie TransactioneXplorer" or similar software can do that?

    My email:hasib.hasan@gmail.com

  • The undocumented function to read the log is fn_dblog. It's a table-valued function (hence used in a select statement), takes two parameters, start LSN and end LSN, both can be null.

    It's completely undocumented, so good luck interpreting it.

    You won't find host names in there, it's a transaction log, not an audit log

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • You can use third party tools to explore the log. They work, but won't supply information that's not there as Gail points out. I think Apex SQL has a log explorer tool.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • You can also use Lumigent Log explorer,SQL Log Rescue avialable in the market to explore the transaction logs.I have written an article regarding teh usage of this software.It can be accessed at http://www.sqlservercentral.com/articles/Product+Reviews/2846/

  • This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply