MS-SQL Compressed Backups Support

[PGN]

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? 

[john_wang · Accepted solution]

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.

[Heinvandenheuvel]

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.

[SushilKumar]

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