Backup a SQL Server Database from On-Premises to Azure Storage
Olujimi Adebiyi
0
Reputation points
Hi there,
Hope you having a better start to the week than mine ...
I am trying to backup an on-prem Sql database to an Azure storage and I have followed the steps highlighted below
- Created a storage account.
- Created and Azure access policy
- Generated the Shared Access Signature (SAS) from the Portal.
- Created Credential using SAS Token.
- Perform backup of the database using Backup to URL command
The thing is the query keeps running for a long time that I am forced to cancel the cancel it then shows an abort error message as well as the true message which is below here
Am I missing some sort of permission somewhere?
Thanks in advance for any suggestions
Cannot open backup device system error 50
IF NOT EXISTS
(SELECT * FROM sys.credentials
WHERE name = 'https://xxxxxxxx.blob.core.windows.net/xxxxxxxxbkup')
CREATE CREDENTIAL [https://xxxxxxxx.blob.core.windows.net/xxxxxxxxbkup]
WITH IDENTITY = 'SHARED ACCESS SIGNATURE',
SECRET = 'si=xxxxxxxxbkup_&spr=https&sv=2022-11-02&sr=c&sig=9nhsgwskshdsjsgsgshsgsh3D';
BACKUP DATABASE DatabaseName
TO URL = 'https://xxxxxxxx.blob.core.windows.net/xxxxxxxxbkup/xxxxxxxx_backup.cobak'
WITH --credential ='https://xxxxxxxx.blob.core.windows.net/xxxxxxxxbkup',
COPY_ONLY,
--NAME = N'DataHosting_Claremont-Full Database Backup',
COMPRESSION,
STATS = 1
Error Message
Msg 3201, Level 16, State 1, Line 73
Cannot open backup device 'https://xxxxxxxx.blob.core.windows.net/xxxxxxxxbkup/xxxxxxxx_backup.cobak'. Operating system error 50(The request is not supported.).
Msg 3013, Level 16, State 1, Line 73
BACKUP DATABASE is terminating abnormally.
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,192 questions
Sign in to answer