Alternate backup folder for SQL Server in Replicate running in Linux

marcioribeiro — Mon, 21 Mar 2022 19:13:33 GMT

Hi,

I'm running Qlik Replicate in Linux. I've configure a SQL Server source with change processing mode as "Backup Logs Only". Now I'm trying to configure the option "Alternate backup folder". First I try to configure as "\\x.x.x.x\backup", however it failed. Then I copied the backup to Linux server using winscp, and it failed as well. In both cases, Replicates concatenated an double slash "//" between the folder I put in "Alternate backup folder" and the name of backup file. See this example:

mssql_locate_log_storage_unit(...) Outputs: StorageUnitDevice=D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\testdb_inc.bak
mssql_compose_alternate_backup_file_spec(...) : /tmp/backup//testdb_inc.bak

Alternate backup file '/tmp/backup//testdb_inc.bak' does not exist. Waiting 10 seconds...

Have someone know how exactly to configure this "Alternate backup folder" option in a Replicate running in Linux ?

Re: Alternate backup folder for SQL Server in Replicate running in Linux

Steve_Nguyen — Tue, 22 Mar 2022 14:00:38 GMT

try :

need to set a path that is available to the SQL Server as the backup is reading using an API via the SQL Server.

SQL Server is running on Windows, so Windows format path.

topic Alternate backup folder for SQL Server in Replicate running in Linux in Qlik Replicate

Alternate backup folder for SQL Server in Replicate running in Linux

Re: Alternate backup folder for SQL Server in Replicate running in Linux