Search code examples
sqlazurebackup

Backup of Azure SQL Database to Recovery Services vault


I'm trying to figure out if there is a way to backup Azure SQL Databases (Not SQL on Azure VMs) to a service vault or a blob storage outside of the resource group the databases is located in. So far I have not found any resources on the topic. Can anyone confirm that this is not possible?


Solution

  • Yes, it's possible.

    The easiest way is that you could using Export to backup the database to blob storage outside of the resource group the databases is located in On portal.

    For example:

    Export: enter image description here

    Export database: enter image description here

    Choose the blob storage out of the resource group which the databases is located in: enter image description here

    For more details, please reference: Export an Azure SQL database to a BACPAC file.

    Hope this helps.