In previous post, we saw
1. How to implement Off-site/Cloud backup in SQL Server 2017 using Azure Blob Storage
2. How to restore SQL Server Backup from Azure Blog Storage using queries
In this post we will see how to restore SQL Server Backup from Azure Blog Storage using SQL Server Management Studio
Step 1: Open SQL Server Management Studio 2017 and connect to SQL Server on which you would like restore the database and right click on “Databases” node and click on “Restore Database…”
Step 2: Select Backup media type as “URL” and click on “Add”
Step 3: Click “Add” to add the new Azure Storage container
If you are not already signed in, sign in to Azure account and then select the Subscription, Storage account and blob container
Based on you requirement, set up the Expiration date for Shared Access policy, by default, its setup for 1 year from date of setup
Click on “Create Credential” to generate the Shared Access Signature (SAS), once SAS is generated successfully, click “Ok” to continue
Step 4: Please review the selected Azure Storage Container and Shared Access Signature and click “Ok” to continue
Please select the backup file, you wish to restore
Please review the selected backup media and click “Ok” to continue
Step 5: Based on requirement change other options in Files tab or Options tab and click “Ok” to start the restore process
Once restore is completed, we should see this restored successfully message
We should also be able to see the database restored in Object Explorer as well
Hope you find this post helpful !!!
Share this:
SQLXpertise 