473,387 Members | 1,834 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Use transaction log to restore change data capture table

I am wondering how to use transaction logs to recover change data capture tables.

I figured out that CDC can view trx logs, and capture some specific data. But, once this is done, change data capture cannot process this data again. I need data to be processed again because my db was restored without the KEEP_CDC options
Nov 13 '13 #1

✓ answered by David Townsend

Pulling out the data manually, and adding it into change data capture tables is very complex.

You can use undocumented functions to get this done: fn_dblog and dbcc log.

Another option is to use log readers. Be aware that these are able to view only what’s written inside transaction log. You’ll need to figure out how to take these records, shown by transaction log readers, and insert them into change data capture tables

1 1429
Pulling out the data manually, and adding it into change data capture tables is very complex.

You can use undocumented functions to get this done: fn_dblog and dbcc log.

Another option is to use log readers. Be aware that these are able to view only what’s written inside transaction log. You’ll need to figure out how to take these records, shown by transaction log readers, and insert them into change data capture tables
Nov 13 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Andrus Moor | last post by:
To reproduce: run the following code in IE 6 and right-click in table. Observed result: Error : invalid argument at line var row = table.insertRow(0); Expected result: new row must be...
2
by: Tonya | last post by:
Hi, i wanted to know how i could resolve the following error message: An unhandled exception of type 'System.ArgumentException' occurred in system.dll Additional information: The data grid...
1
by: krian | last post by:
Hi, I need a help from anybody. My problem is here I wrote two WebApplication in ASP.net Using C#. The name of the applications are (Journal.aspx and Payment.aspx). These Two pages have DataGrids...
2
by: gaston | last post by:
Hi All I have three data bases with a table each one, what I want to do is to get the data from each table and insert it in a new data base table. The thing is that may be there is going to a...
4
by: Baladin | last post by:
Hi I've got a form for Data Capture with loads of Text boxs with the same name, except with a different number at the end, oh and im using VB 2005 i.e. txtName1 txtDOB1 txtName2 ...
5
by: Dmitriy Lapko | last post by:
Hallo all Is it possible to change schema of table in DB2 v.8.2 without recreating and coping a table into a new schema? I need it for several purposes, one of them - refactoring of existing...
1
by: rahullko05 | last post by:
Hi, i am building a small forum site as my final year project & stuck in a very trivial problem. I have a table which are varchar type of data & i am trying to fetch data from table based on...
2
by: shimul | last post by:
Hi, Have table with data ( like a,b,c,d in column 1), want to read data from table and put in text box in continuous form. like tble name "tbltest" and textbox name "txtbox". now want to...
3
by: bluethunder | last post by:
Good day everyone, I'm having a hard time with my program on how to display the data from table to combo box. I have two tables that have been LEFT JOIN to have their relationship in the Data...
0
by: naveendb2dba | last post by:
while loading the PK COLUMN data into table I am getting the duplicate key in a table because of PK COLUMN having auto increment. My requirement is what ever data having the ORIGINAL TABLE that...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.