Azure Sql Database back up files RRS feed

  • Question

  • Hi,

    We are new to Azure SQL Database and doing some research about the backup files. I have few questions related to SQL Database. 

    1) I read that Azure has built-in backup capabilities. I don't see the back up files in the azure portal. We want to use the automated backup files and restore the database in our local environments. Is there any way to access the back up files. 

    2) I used the SQLPackage.exe command to export the database to my local machine. With this approach it is only allowing me to export a bacpac file. Is there anyway other way to take backup files with extension of .bak

    The overall goal is to take a weekly full backup and daily differential backups, which would allow us to restore the database in local. Please suggest us the best options to do so.

    Thanks in advance.


    Tuesday, January 7, 2020 2:34 PM

All replies