asked on 1/13/2019

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.

Databases Azure SQL

Last Comment

Lev Seltzer

1/17/2019

ASKER CERTIFIED SOLUTION

Pratik Somaiya

1/13/2019

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

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

Lev Seltzer

1/13/2019

ASKER

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

1/13/2019

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

D B

1/14/2019

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.

Lev Seltzer

1/17/2019

ASKER

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!