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