Did you know you can back up (and restore) your SQL data to (and from) your Azure Storage Account? No… Check out the following article ; SQL Server Backup to URL
Now head over to your SQL Management studio and create the following credential…
CREATE CREDENTIAL [https://kvaestest01.blob.core.windows.net/sqlbackup] WITH IDENTITY='kvaestest01', SECRET='Dnwkn...SydB...gfsZjm...TJ9Ew=='
- Credential Name : The url of your backup location
- Identity : The name of your storage account
- Secret : The primary access key
And you will see it pop up in your objects…
Now we are ready for the action!
BACKUP DATABASE AdventureWorks2012 TO
URL = 'https://kvaestest01.blob.core.windows.net/sqlbackup/AV2012_01.bak'
WITH CREDENTIAL = 'https://kvaestest01.blob.core.windows.net/sqlbackup'
,STATS = 5;
One thing to note. You can only use one URL in your backup command. So multiple backup files for concurrency reasons is sadly not possible.