Installation and setup of replication on sql server for reading data from SQL Server backup logs

[Rak]

Installation and setup of replication on sql server for reading data from SQL Server backup logs using qlik replicate tasks. 

We have plans to use Qlik Replicate to read data from SQL Server backup logs, is it still necessary to configure replication in SQL Server and enable it?

Please provide documentation on reading from backup logs and its connection to replication.

[Dana_Baldwin]

Hi @Rak 

Yes, you still need to enable MS-Replication so that the CDC data is written to the TLOG.

Documentation on configuring the advanced options in the source endpoint are here:

Setting advanced connection properties #Setting advanced connection properties | Qlik Replicate Help

Pre-requisites are here:

Prerequisites | Qlik Replicate Help

These links are for version 2024.5, you can scroll to the top left and change it for the version you're working with.

Thanks,

Dana

[john_wang]

Besides @Dana_Baldwin comment, if you want to read changes from from backup logs only then please set:

Change processing mode (read changes from) to Backup Logs Only, as:

Hope this helps.

John.