topic Re: SQL Server LOG_BACKUP full in Qlik Compose

SQL Server LOG_BACKUP full

JacobTews — Fri, 14 Mar 2025 20:49:07 GMT

We run Compose on-prem, writing to a SQL Server instance also on-prem. Our DBA has 4-hour backups for all the company's SQL Servers which is supposed to truncate the transaction logs for all the databases after doing so. However, the logs for both my test and production data warehouse databases seem to be immune to such truncation:

Notice in particular the fact that the log for the test data warehouse is actually bigger than the test data warehouse itself!

Any systems-knowledgeable folks out there have any insights?

Is there a setting in Compose that I have inadvertently toggled to cause such behavior?

Re: SQL Server LOG_BACKUP full

JacobTews — Tue, 07 May 2024 21:35:37 GMT

To clarify, I actually got the error messages from , not Compose, but since everything is on the same server, it seems like the DW logfiles are the issue?

Re: SQL Server LOG_BACKUP full

sureshkumar — Wed, 08 May 2024 08:57:18 GMT

Hello @JacobTews
I would suggest creating a post in Replicate Form on the issue

Qlik Replicate Discussions | Qlik Community

Regards,
Suresh