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

8/22/2022 - Mon
Pratik Somaiya

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Lev Seltzer

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.
Pratik Somaiya

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 :)

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.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Lev Seltzer

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!