Great article, I would like to know more about how to handle disruptions:
- Server crash
- SQL Server instance restart
- CDC package fails half way
- CDC Package fails due to time out or network error
- CDC Package fails due to transaction log full
- Source table DDL Changes like add a column and populate it
Should I just rerun the CDC in Reprocessing mode?
In my scenario I track a table which is updated once a day.