1

I am looking for a way to backup an azure sql database to a local server. The backup should be created automatically.

How can I do that?

Thanks in advance!

julius
  • 81
  • 1
  • 8

1 Answers1

1

You can't use BACKUP - since Azure SQL Database is always a newer version than any other version of SQL Server that you can install.

The way to do this is to extract a BACPAC and then apply that to your local server

If you want the local copy to be updated regularly - but not continuously, AND the local copy does not get updated, then consider Azure Data Sync

Martin Cairney
  • 1,714
  • 1
  • 6
  • 18
  • Thanks! Do you have a recommendation on how to extract a BACPAC and apply that to a local server automatically? – julius Feb 09 '21 at 10:50
  • I'd do this with PowerShell and schedule it from the local server. Install DBA Tools modules to make your life a bit easier as well. You will extract it out to an Azure Storage Blob, download it and then load it locally using sqlpackage.exe – Martin Cairney Feb 09 '21 at 12:17