The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
Emergency Truncate of SQL Server TLOG
Without going into the many different reasons why a MS SQL Server source DB TLOG is not getting truncated this article will discuss the steps needed manually truncate the log.
If you notice that the source MS SQL endpoint Database is not truncating after a DBA issues the backup/truncate command it is generally because there is an open transaction that prevents the command from archiving all of the TLOG. What you see is that the source Database TLOG is continuing to grow possibly with the undesirable result of running out of disk space.
If this is an emergency you can do the below steps: no need to stop Replicate task:
