Tagged Questions

0
votes
2answers
33 views

Can I recover CDC tables from transaction logs?

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 ...
1
vote
2answers
46 views

Can we Configure Change Data Capture in another Database?

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?
2
votes
1answer
280 views

In Change Data Capture (CDC), how to configure retention with success?

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 ...
3
votes
2answers
243 views

Can CDC or Change Tracking be implemented against a SQL Server 2012 AlwaysOn read only secondary?

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 ...