Is there anyway to restore CDC tables from transaction logs? My basic understanding is that CDC reads these logs, and entries that are specially marked, are grabbed by CDC. Once this has happened though, this data is no longer flagged for harvesting by CDC.
I need this to happen because a DB was restored without any KEEP_CDC options.
MS SMS, 2008 R2, sql server 10.5.16