Click here to Skip to main content
15,878,959 members
Please Sign up or sign in to vote.
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

 
Share this answer
 
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 :(
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
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900