How to backup an Azure SQL Database to On Prem?

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

Answer 1

https://msdn.microsoft.com/en-us/library/jj919148.aspx?f=255&MSPPError=-2147217396

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

https://azure.microsoft.com/en-us/solutions/architecture/backup-archive-on-premises-applications/

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

Answer 2

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

Answer 3

Thanks people.. much appreciated..