One of the tasks that any DBA should know How to take backup to URL or restore a backup from URL and this’s the easiest part very simple steps and command but this is not our main objective, we should understand all of the components how it is working, what is the different options, what is the changes happened before SQL Server 2016 and After SQL Server 2016 to take the maximum benefits from this service or feature here in my article I will try to conclude all of this things as much as I can.
- Introduction.
- Benefits from taking backup to URL.
- What is Azure Storage Blob?
- What are the Pre-requisites to do SQL backup on the URL?
- What is the Difference between SAS Token and access key Azure Storage
- When I Should use SAS Token or access key Azure Storage
- When the Backup files will be saved as Block Blob or Page Blob
- How to Generate and configure Access Policy, Access key, and Shared Access Signature
- Create SQL Server Credential using access key or SHARED ACCESS SIGNATURE
- Backup to Azure Storage and restore from Azure Storage.
- Validate the Backup File.
- Notes and Limitation for SQL backup to URL.
- References and Resources.
DB Cloud TECH 