Explanation:
Box 1: CREATE CREDENTIAL
[https://<
Create a credential.
The following examples create SQL Server credentials for authentication to the Microsoft Azure Blob Storage service.
CREATE CREDENTIAL
[https://<mystorageaccountname>.blob.core.windows.net/<mystorageaccountcontainername>] WITH IDENTITY = 'SHARED ACCESS SIGNATURE', SECRET = '<SAS_TOKEN>'; Incorrect:
The other CREATE CREDENTIAL option does not refer to mysqlbackups - the name of the account.
Box 2: BACKUP..
Do no include WITH CREDENTIAL when backing up To URL using Shared Access Signature.
Example:
BACKUP DATABASE AdventureWorks2016
TO URL =
'https://<mystorageaccountname>.blob.core.windows.net/<mycontainername>/AdventureWorks2
016.bak';
Box 3: RESTORE
Do no include WITH CREDENTIAL when restoring up To URL using Shared Access Signature.
Example: BACKUP DATABASE AdventureWorks2016
TO URL =
'https://<mystorageaccountname>.blob.core.windows.net/<mycontainername>/AdventureWorks2
016.bak';
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to- url?view=sql-server-ver15