I am trying to extract all information (Insert, Update and Delete Operations) from the transaction log file of SQL Server manually. For this work, I am using the undocumented functions
fn_dump_dblog for SQL Server.
There are 3 allocation units (
sys.allocation_units) in transaction log file Partition (
In all of these allocation units, we found a
RowLogContents0 column that contains the data of that row in hexadecimal format. I can get real data from the
RowLogContents0 column, when I have an
IN_ROW_DATA allocation unit type in my table. But when I have
LOB_DATA allocation unit type in my table then I am unable to get data from
Does anyone know how I can get data using
RowLogContents0 column which is stored in
LOB_DATA allocation unit type?
I am following these links to get inserted and updated data from logs:
Now I am able to get these records and queries. But facing problem when trying to get LOB records as describe above.
Note : I don't want to use any third party tool to do this, because I am trying to make a third party tool for my program. Right now we are only focusing on SQL Server 2008 R2.