解析事务日志 [英] Parse a transaction log

问题描述

我想知道，如何读取sql事务日志（* .ldf文件）......



所以，我找到了一个程序......本网站：http：//raresql.com/2012/02/01/how-to-recover-modified-records-from-sql-server-part-1/



（我不能把程序放在这里，因为代码太大了......）



在那个网站上，有一个程序可以做到这一点，但是我想知道，我需要修改的方法和内容（我真的不知道，所以请问），我只想获取修改值，而不是生成UPDATE语句，就像在网站中一样......，所以，例如，我在过程参数中输入LSN号，并且，程序返回给我（解析的logrow或类似的东西......）一个更简单的系统....顺便说一句，我只是想知道，如何这个，因为，对我来说，这个程序太复杂了：（

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 :(

推荐答案

尝试其中一些： HTTPS：？//www.g oogle.com/search?q=read+the+sql+transaction+log [ ^ ]。

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

有一些未记录的函数，如DBCC LOG或fn_dblog，可用于读取sql事务日志。那些需要t-sql知识，如果你对它们不够熟悉则使用起来很复杂。



我建议你仔细阅读：

阅读SQL Server事务日志

读取sql server 2008中的日志文件（* .LDF）

如何查看交易日志在sql server 2008



这些帖子肯定会让你开始

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

这篇关于解析事务日志的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！