Parse a transaction log

Question

0.00/5 (No votes)

See more:

I want to know, how to read the sql transaction log ( *.ldf file )...

So, I found one procedure... in this site: http://raresql.com/2012/02/01/how-to-recover-modified-records-from-sql-server-part-1/

( I can't put the procedure here, because the code is too big... )

In that site, have a procedure to make this, but I want to know, how and what I need to modify ( I REALLY DO NOT KNOW, SO AM ASKING ), I just want to get the modify values, without generate a UPDATE statement, like in the site..., so, for example, I enter with the LSN numbers in procedure parameter, and, the procedure return for me ( the parsed logrow or something like this... ) a more simple system.... btw, I just want to know, how to make this, because, for me, that procedure is too much complex :(

Posted 2-Jan-14 1:34am

Alexandre Bencz

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bogdan Ionesku · Answer 1 · 2014-01-30T21:39:00

There are undocumented functions like DBCC LOG or fn_dblog you can use to read sql transaction log. Those require a t-sql knowledge, and are complex to use if you are not familiar enough with them.

I suggest you read these carefully:
Read SQL Server transaction log
Read the log file (*.LDF) in sql server 2008
How to view transaction logs in sql server 2008

These posts will definately get you started

Richard MacCutchan · Answer 2 · 2014-01-02T01:37:00

Solution 1

Try some of these: https://www.google.com/search?q=read+the+sql+transaction+log[^].

Posted 2-Jan-14 1:37am

Richard MacCutchan

Comments

Alexandre Bencz 2-Jan-14 7:38am

was the first thing I did ...

Richard MacCutchan 2-Jan-14 7:44am

The fifth link explains how to do it. What is your actual difficulty?

Alexandre Bencz 2-Jan-14 7:49am

I just want to simplify this procedure, only to return me the information without creating the update command...
for example, I enter the parameters of the procedure with the LSN range that I want him back to me, and it returns me the information, I believe, it is not complicated, because virtually everything is already done, but I do not know how do this :(