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 ...
I want to apply Change Data Capture(CDC) to database DB1's tables and want to log everything in DB2. So, could it be possible to capture table DB1's changes to DB2?
We have CDC enabled on SQL Server 2008 with retention re-configured to a number other than the default 3 days (or something similar). When we first configured it (with default options), it worked ...
We will be deploying SQL Server 2012 AlwaysOn with read only secondaries and would like to execute our SSIS extracts against the secondary while utilizing CDC or change tracking (the decision hasn't ...