SQL Server Snapshot Modes

When a SQL Server connecor is started, there are various options. The default is when_needed. The other options may be useful from time to time.

Option

Description

initial

The connector performs a snapshot if no offsets have been recorded for the logical server name.
always: The connector performs a snapshot every time it starts

when_needed

The connector runs a snapshot upon startup when no offsets are available or when a previously recorded offset refers to a binlog location that is unavailable on the server