How CDC Replication responds to end on error during mirroring
CDC Replication responds to an end on error during mirroring in a manner that safeguards data integrity.
An end on error during mirroring can occur for several reasons, including a user issuing an abnormal termination or an error on the Kafka server.
A subscription that is subsequently started in mirroring mode will start replication with the transaction that immediately followed the last known committed transaction. This method ensures that all operations for partially written transactions at the time of shutdown are guaranteed to be written in whole at restart time.