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.
|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|
Updated 5 months ago