Azure SQL Database and Backups

Question, can you take a built-in backup ( a backup that Microsoft takes as part of the service) and create a new database from it on a NEW server in a different region?

Let’s find out.

I have 2 logical SQL servers, both in different regions, West Europe and UK South.

sqllocation

Within milkyway I have few databases, can I for this example create from a backup cloudDB over on testeraks?

clouddb

What you need to do it go to the TARGET server (testeraks) and click create database.

create1

Then within the create wizard you need to look for additional settings.

addsetting

Here you select the data source as a backup.

backups1

It will use the most RECENT GEO-REPLICATED backup. It will takes couple of minutes to build the list of backups for you.

thelist

And there it is. You can.

completed

 

2 thoughts on “Azure SQL Database and Backups

  1. Pingback: Deploying an Azure SQL DB Backup to a New Region – Curated SQL

  2. Pingback: Business Continuity in SQL Database | James Serra's Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s