locked
How to backup an Azure SQL Database to On Prem? RRS feed

  • Question

  • Hi All

    Could someone advise me if there are ways to back up an Azure database (PAAS) to an On Prem location?

    Also can we restore a database to Azure from an On Prem location?

    Cheers

    Nithin


    Tuesday, February 21, 2017 5:13 AM

Answers

  • Hello,

    You can create a bacpac of the SQL Azure database and store it on a storage account on Azure and download it from there to your organization. You can also restore a bacpac from on premises to SQL Azure by uploading the bacpac on a storage account and restore it from there.

    https://sqldacexamples.codeplex.com/

    Backups of SQL Server instances cannot be restored on SQL Azure.

    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com



    Tuesday, February 21, 2017 11:13 AM

All replies