Qlik Replicate (MS REPLICATION) and Veeam backup solution

[jorgetrillo]

Hello,

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

Is it possible?

[Steve_Nguyen]

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.

[john_wang · Accepted solution]

Hello @jorgetrillo ,

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

Regards,

John.

[SwathiPulagam]

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

[Michael_Litz · Accepted solution]

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