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