Qlik Replicate: SQL Server supported 3rd party backup devices

Alan_Wang — Tue, 04 Jun 2024 09:21:30 GMT

Qlik does not have a list of supported 3rd party backup devices that Qlik Replicate is able to read. Generally, any 3rd party backup devices that use the TRN format will not have issues with the task reading from them. 3rd party backup device support can be turned on from the SQL Server source endpoint in the advanced tab by checking 'Select virtual backup device types'

Unsupported 3rd party backup devices will lead to errors reading from the backup files like the following error message where IDERA SQL SAFE is not supported.

Failure in starting (with TXN consistency...)
Failure in resolving stream position by TIMESTAMP
RetCode: SQL_ERROR SqlState: 42000 NativeError: 3241 Message: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The media family on device '\\sqlbackup.domain.com\sqldatabackup\MKTMPRLAWSQL01\PROD\MKTMPRLAWSQL01_PROD_Log_202405092000.safe' is incorrectly formed. SQL Server cannot process this media family. Line: 1 Column: -1
Failed (retcode -1) to execute statement: '
select top 1 [Current LSN]
from sys.fn_dump_dblog (NULL, NULL,NULL, 1,'\\sqlbackup.domain.com\sqldatabackup\MKTMPRLAWSQL01\PROD\MKTMPRLAWSQL01_PROD_Log_202405092000.safe',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
where operation='LOP_BEGIN_XACT'
and convert(datetime,[Begin Time],121)>= cast('2024-05-09T19:35:41' as datetime)

Environment

SQL Server Source endpoint

article Qlik Replicate: SQL Server supported 3rd party backup devices in Official Support Articles

Qlik Replicate: SQL Server supported 3rd party backup devices

Environment