Restore SQL Server database using SAS from Azure Blob Storage

You need to create a SQL Server credential first to restore a database back up from Azure blob storage. A lot of writings can be found around the web on this. Most of them have used Azure Storage Account to create the credential in the first place. In this short post, I will be using SAS (Shared Access Signature) to create the credential first. So, here you go..

Following is a snapshot of a credential created using SAS. Identity will be SHARED ACCESS SIGNATURE and Password will be your <SAS token>.

Once, it is created you can now go to Restore database or Restore File or File-groups option

And finally use the credential created at the beginning to locate your back up file in Azure storage

Use your back up file’s URI in Shared Access Signature area.

If you like to use scripts to perform all these actions, you can follow this tutorial from Microsoft

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-get-started-restore

 

Advertisements

About Zahid

Team Lead at IQVIA (www.iqvia.com). Fields of expertise are C#,BI Reporting (MSBI, Microstrategy, Excel, ASP.NET Dashboards etc.) , ETL, Data Warehouse, OLAP Cube, MDX etc.
This entry was posted in Azure, SQL, Database and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.