Error: Reading From the Backup Device Type 9 ('URL') Is Not Supported

Issue

Syncs fail with the following error:

Reading from the backup device type 9 ('URL') is not supported.

Environment

• Connector: High-Volume Agent SQL Server
• Transaction logs backups stored in Azure Blob Storage or a similar cloud storage service

Resolution

To resolve this issue:

1. Trigger a historical re-sync to retrieve missed transactions directly from the source database instead of using the unsupported URL-based backups. For instructions, see How to Trigger Historical Re-Syncs.
2. Work with your database administrator to store transaction log backups on an accessible local or network file system that you can access as a standard disk path.

For backup requirements, see the High-Volume Agent SQL Server Setup Guide.

Cause

The High-Volume Agent SQL Server connector doesn't support reading transaction log backups created using BACKUP TO URL, including backups stored in Azure Blob Storage.