Blog Post

Azure SQL Blog
1 MIN READ

New Data Exposed episode: It’s just SQL: Restoring a database to Azure SQL DB from backup

dutchdatadude's avatar
dutchdatadude
Icon for Microsoft rankMicrosoft
Oct 10, 2019

In this video, Jeroen ter Heerdt shows how to restore a database to Azure SQL from a BACPAC file.

Read more about importing an Azure SQL Database from BACPAC.

 

Published Oct 10, 2019
Version 1.0
  • m60freeman's avatar
    m60freeman
    Brass Contributor

    This is all true, unless you have a large database. A BACPAC file is not a true backup, it is a compressed script consisting of a series of commands to recreate your database's structure, and then populate it by inserting the data into each table (in an order optimized to avoid foreign key issues) one row at a time. There are two possible performance issues with this. One is that is can be very slow due to the row by row nature of the inserts. The other is that behind the scenes, Azure uses a VM to process the import. This describes a possible performance problem related to that.

     

    We have run into cases where the restore fails entirely because the special Compute VM Azure uses doesn't have sufficient capacity.