file folder backup vs advanced folder backup

The Alternate backup folder must be a common shared network folder, for example: \tempackup. When Qlik Replicate has file-level access to the backup transaction logs, the following rules apply: Replicate has file-level access to the backup log files: Select this option if Qlik Replicate has been granted file-level access to the backup log files in the Alternate backup folder. Online Logs Only - When this option is selected, Qlik Replicate will try and find the changes in the online transaction logs only.The actual latency time will remain constant, but will vary according to the backup schedule. Selecting this method results in increased latency due to the interval between backups. Backup Logs Only - When this option is selected, Qlik Replicate will try and find the changes in the backup transaction logs only.If the changes cannot be found in the backup transaction logs, it will look for them in the online transaction logs instead. This can improve performance when reading from the online transaction log is slow (e.g due to lock contention) or when using file-level access to access the backup transaction logs. Prioritize Backup Logs - When this option is enabled, Replicate will first look for the changes in the backup transaction logs. If the changes cannot be found in the online transaction logs, it will look for them in the backup transaction logs instead. Replicate will first look for the changes in the online transaction logs.

Prioritize Online Logs - This is the default.

Note that the backup files must be exported to the specified location in standard Microsoft SQL Server format.Ĭhange processing mode: Choose one of the following change processing modes: You can run the backup utility yourself or you can configure Qlik Replicate to run it as described in Backup file preprocessing command below. instead of Microsoft SQL Server’s own backup mechanism). 1) may adversely affect task processing, and possibly even result in an error.Īlternate backup folder : The location of the backup logs when using a third-party utility to back up the transaction logs (i.e. If the Exclusively use sp_repldone within a single task option is also selected, setting a very short interval (e.g. Therefore, if you need to run parallel Qlik Replicate tasks against the same database, use the default method. Also, using this method, only one Qlik Replicate task can access the database at any given time. Although this method does not involve any transactional activities, it can only be used when Microsoft Replication is not running. The table can be safely deleted if there are no tasks configured with the Start transactions in the database option.Įxclusively use sp_repldone within a single task: When this method is used, Qlik Replicate reads the changes and then uses sp_repldone to mark the TLOG transactions as ready for truncation. Make sure that the table is not included any maintenance plan as it may cause the maintenance job to fail. This is a very small but important table whose purpose is to prevent truncation of the transaction log by mimicking a transaction in the database. When this option is selected, Replicate creates a table named attrep_truncation_safeguard in the source database. If you need Microsoft Replication to be enabled in your database, then you must choose this method. As long as such a transaction is open, changes that appear after the transaction started will not be truncated.

When this method is used, Qlik Replicate prevents TLOG truncation by mimicking a transaction in the database. Start transactions in the database: This is the default method. To minimize the need to access the backup log, Qlik Replicate prevents truncation using one of the following methods: When this occurs, Qlik Replicate accesses the backup log to capture the missing changes. However, sometimes due to truncation, the active TLOG may not contain all of the unread changes. Prevent truncation of unread changes from TLOG: For optimal performance, Qlik Replicate will try to capture all unread changes from the active transaction log (TLOG). In the Advanced tab, you can set the following properties: Setting advanced connection properties ON THIS PAGE

File folder backup vs advanced folder backup