topic Re: Qlik Replicate (MS REPLICATION) and Veeam backup solution in Qlik Replicate

Qlik Replicate (MS REPLICATION) and Veeam backup solution

jorgetrillo — Tue, 15 Nov 2022 09:15:22 GMT

Hello,

I want to use QLIK Replicate (with MS REPLICATION mode) and Veeam backup solution.

Is it possible?

Re: Qlik Replicate (MS REPLICATION) and Veeam backup solution

Steve_Nguyen — Wed, 16 Nov 2022 13:35:20 GMT

When working with MS-Replication mode, the archived-logs must meet two conditions:
1. The archived logs should be in MS format, otherwise Replicate will not be able to read them.
2. The archived logs should be known to the DB engine, it means that the following query to the MSSQL source, should provide results:
select
[dbo].[attrep_fn_NumericLsnToHexa](bs.first_lsn),
[dbo].[attrep_fn_NumericLsnToHexa](bs.last_lsn),
bmf.* , bs.*
from msdb.dbo.backupmediafamily bmf, msdb.dbo.backupset bs
where bmf.media_set_id = bs.media_set_id
and bs.database_name=db_name() and bs.type='L';

Please consult with the MSSQL dba, if the Veeam backup solution meets these two conditions.

Re: Qlik Replicate (MS REPLICATION) and Veeam backup solution

john_wang — Thu, 17 Nov 2022 08:33:30 GMT

Hello @jorgetrillo ,

There is another article Replication with Veeam Backups for SQLServer , hope it helps.

Regards,

John.

Re: Qlik Replicate (MS REPLICATION) and Veeam backup solution

SwathiPulagam — Tue, 29 Nov 2022 11:25:52 GMT

Hi @jorgetrillo ,

Is your Veeam backup in the Native format? If yes, then Qlik Replicate supports the Veeam backup with MS Replication mode.

Thanks,

Swathi

Re: Qlik Replicate (MS REPLICATION) and Veeam backup solution

Michael_Litz — Tue, 29 Nov 2022 17:16:58 GMT

Hi Jorge,

You could try the relatively new end point called Microsoft Azure SQL (MS-CDC), it will work with regular MS SQL.

This end point does not need access to the TLOG backups in any way so it would not matter what third party tool you use for that.

It will rely on using the MS-CDC that you configure inside of SQL.

Thanks,
Michael