Skip to content

DatabaseBackup not allowing valid MaxTransferSize #1128

Description

@briansreiff

According to Microsoft's documentation, MaxTransferSize can be up to 20MB when backing up to Azure blob storage.
However, the DatabaseBackup procedure raises an error if @MaxTransferSize > 4194304 AND @URL LIKE 'https%' AND @Credential IS NULL AND @BackupSoftware IS NULL.

SQL Server version and edition
Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: )

Version of the script
Version: 2026-07-23 23:22:18

What command are you executing?
EXECUTE [master].[dbo].[DatabaseBackup]
@databases = 'USER_DATABASES',
@url = 'https://myaccount.blob.core.windows.net/Backups',
@BackupType = 'LOG',
@Blocksize=65536,
@MaxTransferSize=20971520;

What output are you getting?
Msg 50000, Level 16, State 7, Procedure master.dbo.DatabaseBackup, Line 2590 [Batch Start Line 9]
The value for the parameter @MaxTransferSize is not supported.

Msg 50000, Level 16, State 1, Procedure master.dbo.DatabaseBackup, Line 2590 [Batch Start Line 9]
The documentation is available at https://ola.hallengren.com/sql-server-backup.html.

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions