Backup SQL Azure database from the Cloud to on-premises (DPM?)

Question

We currently backup our SQL databases in our data centre using Microsoft DPM.

We are now putting some databases into SQL Azure ( SQL Azure Database ).

How can we backup a database from the could to on premises so we have a copy locally?

score 5 · Answer 1 · answered Dec 19 '16 at 17:40

There is nothing easier than backuping a data to virtual tape libraries IMHO. But at the same time, I got to admit that it was a challenge for me to find a compatible solution with Microsoft DPM. I've ended with StarWind VTL: https://www.starwindsoftware.com/starwind-virtual-tape-library I actually have been using it as some kind of temporary storage for my data-at-rest before it will be offloaded to the cloud. Don't see any reasons why that would not work in reverse order. Hope it helps!

score 0 · Answer 2 · edited May 23 '17 at 12:41

0

There are multiple ways to do this: using SSIS (SQL Server Integration Services), using combination of SSIS and DB creation scripts, using Import/Export service in SQL Azure.

There is a good answer maybe could help you.

edited May 23 '17 at 12:41

Community

1

answered Dec 19 '16 at 02:12

Shui shengbao

3,613

score -1 · Answer 3 · answered Dec 16 '16 at 20:29

-1

Azure SQL already have a built-in backup system, you don't need to have a local copy: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-automated-backups

answered Dec 16 '16 at 20:29

Noor Khaldi

3,879

Backup SQL Azure database from the Cloud to on-premises (DPM?)

3 Answers3