Avatar of Lev Seltzer
Lev SeltzerFlag for Israel

asked on 

How to restore a SQL BAK file to an AZURE Database

I have a BAK file from an MS SQL database, and I want to access the data in it. I have access to AZURE and have created an instance of a MS SQL database, but I can't figure out what to do next. I have read that one cannot restore a BAK file to AZURE, and instead one should restore it to a local database - but I don't know how to do that.

I have MS SQL SMS installed on my Windows 10 computer.
I have an azure account and already created my empty database, but I could delete it and create a new one.
I have the 8mb BAK file on my computer.

Thank you for your help.

Avatar of undefined
Last Comment
Lev Seltzer
Avatar of Pratik Somaiya
Pratik Somaiya
Flag of India image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Lev Seltzer
Lev Seltzer
Flag of Israel image


I do not have a local DB. I have a BAK file. I assume I could turn this into a DB, but I don't know how using SQL SMS.
Try these steps:

1. Upload the BAK file in Azure Storage Account (Blob)
2. Open Azure SQL Server.
3. Go to Import New Database button tab.
4. See the image for reference, and click on the Storage.
5. Select the storage account or container details where your BAK is residing.
6. Click OK and then fill in the required details.
7. Click on OK
8. You are done with it :)
Avatar of D B
Flag of United States of America image

Do you have a local SQL Server you can restore the file to, and then migrate to Azure?
If not, you can download the SQL Server Developer edition, install it locally, restore the database and then use the migration toold to upload it to Azure.
Avatar of Lev Seltzer
Lev Seltzer
Flag of Israel image


Thank you both. I got it working, but I decided to put it on a different server to make it easier, but I still needed a few hours of help from technical support to get it working properly!

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo