Recovery Model when using SQL Server as a Source in QTC Data Integration
Hi Support,
As part of the prerequisites for using SQL Server as a source connection in QTC Data Integration it's stated that "Microsoft SQL Server as a source must be configured for a full backup to work with Qlik Data Gateway - Data Movement" and that the recovery model for the database needs to be set to 'Full'.
When running a pipeline in our test environment, we found that our test SQL Server had its recovery model set to 'Simple' (a warning appeared in the task logs). However, we didn't experience any issues with the full load or CDC, and saw no missing transactions in the target database.
I'd just like to know the potential impact of having the recovery model set to 'Simple' rather than 'Full' on a QTC Data Integration pipeline or landing/storage task.
