Use transaction log to restore change data capture table

[Philip Bulles]

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

[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