Tim Radney restores a database:
I have recently had the privilege of working with multiple clients who have been taking advantage of Change Data Capture “CDC”. Change Data Capture is a feature that utilizes SQL Server Agent to log inserts, updates, and deletes occurring in a table. It makes these data changes available to be consumed in a relational format. These changes are captured for the modified rows and stored in change tables that mirror the column structure of the tracked source tables.
Change Data Capture is very often utilized for ETL projects or for data extracts into a data warehouse, data lake, etc.
Click through for the scenario and how you can keep CDC going after restoring a SQL Server database.