We help IT Professionals succeed at work.

How to restore a SQL BAK file to an AZURE Database

1,400 Views
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.
Comment
Watch Question

Application Development Analyst
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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
CERTIFIED EXPERT

Commented:
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 :)
Backup-SQL-to-Azure.png
Doug BishopDatabase Developer

Commented:
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.

Author

Commented:
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.

OR

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.