September 14, 2012 at 9:41 pm
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
September 15, 2012 at 3:02 am
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
September 17, 2012 at 3:51 am
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
September 18, 2012 at 12:05 am
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/
October 2, 2015 at 10:57 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy