We help IT Professionals succeed at work.

How to restore a SQL BAK file to an AZURE Database

Last Modified: 2019-01-17
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.
Watch Question

Application Development Analyst
This one is on us!
(Get your first solution completely free - no credit card required)


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 SomaiyaApplication Development Analyst

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 :)
Doug BishopDatabase Developer

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.


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!
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.