Hello,

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.