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 |
Updated 29 days ago