topic Re: MS-SQL Compressed Backups Support in Qlik Replicate

MS-SQL Compressed Backups Support

PGN — Tue, 20 Feb 2024 20:50:54 GMT

I seem to remember a few years ago that Replicate was able to support MS-SQL backup logs that were backed up with Compression. However, I can't find any reference now.

I'm starting a new transactional task and am using Native SQL local tlog backups. Is native backup log compression still supported? If so, is there anything I need to set in the connection manager? Can I set it mid-stream? For example, if I begin backing up databases with compression now, and another task needs to go back to look at old log backups that were not compressed, will there be an issue?

Re: MS-SQL Compressed Backups Support

john_wang — Wed, 21 Feb 2024 14:32:30 GMT

Hello @PGN ,

If it's native format compression it should be fine as I remember. You may try to run below query in SSMS to verify the compresed TLOG file, if it works then Replicate would work too.

select * from
sys.fn_dump_dblog ('', NULL,NULL, 1,
'put the fully qualified name of the log here',
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);

Hope this helps.

John.

Re: MS-SQL Compressed Backups Support

Heinvandenheuvel — Wed, 21 Feb 2024 15:18:25 GMT

Yes, Replicate supports alternate backup (and compression) options for SQLserver sources.

Carefully read the Replicate Userguide -

"Alternate backup folder: The location of the backup logs when using a third-party utility to back up
the transaction logs (i.e. instead of Microsoft SQL Server’s own backup mechanism). You can run the
backup utility yourself or you can configure Qlik Replicate to run it as described in Backup file
preprocessing command below. "

Search for: "Select virtual backup device types"

and: "Backup folder preprocessing command"

You may want to engage Qlik professional services for further help with this, or perhaps an other forum reader has hands-on experiences to share.

Hein.

Re: MS-SQL Compressed Backups Support

SushilKumar — Thu, 22 Feb 2024 11:07:30 GMT

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar