- Create the Azure Storage: http://www.sqlpanda.com/2014/10/azure-storage-azure-storage-explorer.html
- Create the certificate for encryption: http://www.sqlpanda.com/2014/10/sql-server-2014-backup-encryption.html
backup to Azure Storage
In the Azure portal , get the URL from PRIMARY BLOB SERVICE ENDPOINT
The append the folder name after the URL, the name is case sensitive, in my example, the folder name is backup, if I use Backup , it will get the below error.
Msg 3271, Level 16, State 1, Line 38
A nonrecoverable I/O error occurred on file "https://sqlpanda001.blob.core.windows.net/Backup/AzureDB.bak:"
Backup to URL received an exception from the remote endpoint. Exception Message: The remote server returned an error: (400) Bad Request..
Msg 3013, Level 16, State 1, Line 38
BACKUP DATABASE is terminating abnormally.
Restore from Azure Storage
- Create certificate from the source server certificate backup
- Create credential as source server