Edit on GitHub
Are the Existing CDC Tables and Articles Dropped in SQL Server During HVR Initialize?link
Questionlink
Are the existing CDC tables and articles dropped in SQL Server during HVR Initialize?
Environmentlink
HVR 5
Answerlink
Yes, if you select the Drop Objects and Supplemental Logging options for the HVR Initialize, the existing CDC tables for the tables in HVR replication are dropped on the source database. This means that the other processes which are using these CDC tables will not see them anymore.
The articles are dropped only for the tables that are replicated by HVR.
The options shown in the following image will drop the CDC/Articles for the district
and orders
tables:
The options shown in the following image will drop the CDC/Articles for all the tables except new_order
and orders
: