How to use Backup-SqlDatabase with SAS token?

Question

I'm trying to implement log shipping using Backup-sqldatabase command, but SqlCredential is a required parameter for Azure Storage uploads according to the docs. However, I'm using a Shared Access Token credential, so I can't really use the SqlCredential parameter. If I do, this is the error I get:

Backup-SqlDatabase : System.Data.SqlClient.SqlError: Use of WITH CREDENTIAL syntax is not valid for credentials containing a Shared Access Signature.

Does this mean that SAS tokens/credential can't be used for Backup-sqldatabase?

If I don't include the SqlCredential parameter, I get this error:

Backup-SqlDatabase : System.Data.SqlClient.SqlError: The file name "https://xxxxdev.blob.core.windows.net/DESKTOP-MCxxxx-MSSQL15.MSSQLSERVER-Test123-132767637897201085.bak" is invalid as a backup device name for the specified device type. Reissue the BACKUP statement with a valid file name and device type.

Test123 is just a random test database I created on localhost for testing purposes.

halfer · Accepted Answer · 2022-04-16 21:46:42Z

0

Looks like SAS token is not supported for Backup-sqldatabase at this time.

The workaround is creating a Maintenance Plan, but that means T-SQL backups no PowerShell.

In this article, you can learn how we can fix the ‘WITH CREDENTIAL syntax is not valid for credentials containing a Shared Access Signature’ error and learn to back up the SQL database to Azure Blob storage using the SQL Server maintenance plan.

edited Apr 16, 2022 at 21:46

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Sep 22, 2021 at 19:38

Cataster

3,6019 gold badges48 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use Backup-SqlDatabase with SAS token?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related