Read SQL T-log backups from Azure Blob storage as Alternate backup folder in the source end point

[balleda2]

How to set the SQL T-LOG backups from the Azure Blob storage as Alternate backup folder for CDC read changes from backup logs only. If no, when would this be for GA  and are there any alternate solutions immediately available to access the backups from the Azure Blob

[john_wang]

Hello @balleda2 ,

Thanks for reaching out to Qlik Community!

Accessing transaction log (TLOG) backups stored on Azure Blob Storage for an Azure SQL Server database depends on the deployment model you're using. For example Azure SQL Managed Instance (MI) does not provide the TLOG access.

You might want to use the below endpoints for your SQL Server replication:

• Using Microsoft Azure SQL Managed Instance as a source
• Using Microsoft Azure SQL (MS-CDC) as a source

Hope this helps.

John.

[balleda2]

@john_wang this is not a SQL MI, it is SQL server in Azure VM and the backups are taken into the Azure Blob instead of the shared drive. Our  Qlik CDC task is replicating the data currently reading the tlog backup logs from the shared path, whihc will be replaced by the azure blob. Is it possible to add the Azure blob storage path in the Alternate backup folder.

[john_wang · Accepted solution]

Hello @balleda2 ,

Thanks for the clarification.

Alternate backup folder is an OS folder of the Replicate server. It typically expects a file system path, not a cloud URL. So directly specifying an Azure Blob path (like https://<account>.blob.core.windows.net/<container>) may not work. I'd like suggest you opening a support ticket to get confirmation.

Regards,

John.