By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,401 Members | 1,381 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,401 IT Pros & Developers. It's quick & easy.

Use transaction log to restore change data capture table

P: 2
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

Share this Question
Share on Google+
1 Reply


P: 4
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

Post your reply

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