Cannot backup onprem database to Azure Blob container

Nguyen, Hoa 331 Reputation points
2022-08-19T22:05:51.953+00:00

I used the following doc https://learn.microsoft.com/en-us/sql/relational-databases/tutorial-sql-server-backup-and-restore-to-azure-blob-storage-service?view=sql-server-ver16&tabs=SSMS&source=docs to take a backup of the sqltestdb to Azure blob container BUT received an error.

233023-image.png

It did take me thru signing in, getting a SAS but could not run the backup.
Can someone please help throw some light on that error?
(a) is it due to the SMO version of my onprem server and database? If yes, what version of SMO must be installed on the onprem server?
(b) or is it caused by the fact that one CANNOT backup an onprem database to Azure Blob Container?

The plan is to keep the backup in Azure Blob Container and restore it from Azure Blob Container to Azure Synapse SQL dedicated pool when data requests are submitted to run queries.

Thank you!

Azure SQL Database
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,412 questions
{count} vote

Accepted answer
  1. Alberto Morillo 32,796 Reputation points MVP
    2022-08-22T11:26:55.837+00:00

    You cannot restore native SQL Server backups to Azure Synapse by restoring backup files from Azure Storage Accounts. You can export your data to storage account as Text files, make the name of the files meaningful by making date of the export part of the name of the file, and then import them as needed to Azure Synapse. Please read this documentation.

    Please follow these steps, you may find them easier to follow. It is better explained.


0 additional answers

Sort by: Most helpful