Hallengren database backup for TDE enabled databases out to Azure Blob Storage MaxTransferSize #783
Unanswered
chrimps
asked this question in
Questions & Answers
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
In SQL Server 2016 build 13.0.7024.30 I created a credential using a SAS rather than the storage key. I used the following format:
CREATE CREDENTIAL [https://.blob.core.windows.net/]
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = '<SAS_TOKEN>';
If done this way I was under the impression that I could backup a TDE enabled database out to the blob container (URL) with compression enabled, as long as I set the MaxTransferSize > 65536. The format of the Hallengren script I used to run the backup is this:
EXECUTE [dbo].[DatabaseBackup]
@databases = ,
@BackupType = ,
@MaxTransferSize = 65537,
@compress ='Y',
@url =
However, it is failing with this error:
Msg 50000, Level 16, State 3, Procedure DatabaseBackup, Line 2268 [Batch Start Line 0]
The value for the parameter @credential is not supported.
Any ideas how to get around this? For the record, I love and appreciate everything Hallengren has created and shared.
Beta Was this translation helpful? Give feedback.
All reactions