Sync fails for MS SQL source connector after CDC cleanup

### Connector Name

source-mssql

### Connector Version

4.1.27

### What step the error happened?

During the sync

### Relevant information

Whenever the CDC cleanup job runs, Sync starts failing with the error "Failure in source: Saved offset no longer present on the server"

Though there are no new records inserted in the CDC tables since the last successful sync

As well as the Sync schedule is set to 5 mins in Airbyte, so the sync is happening much faster than the clean up job

Aitbyte version - 1.6.2
source-mssql - 4.1.27

### Relevant log output

```shell
source ERROR main i.a.c.i.b.s.SshWrappedSource(read):72 Exception occurred while getting the delegate read iterator, closing SSH tunnel io.airbyte.commons.exceptions.ConfigErrorException: Saved offset no longer present on the server. Please reset the connection, and then increase binlog retention and/or increase sync frequency.
```

### Contribute

- [x] Yes, I want to contribute