Recently I encountered an issue while trying to reinitialize transactional replication subscription through backup and restore method due to timestamp column in a published table. In this article, we will discuss about the relation and the impact of timestamp column with SQL server replication.

What is Change Data Capture (CDC)?

Change data capture (CDC) uses SQL Server agent to capture DML activities like deleting, updating, and inserting on a table.