Backing up SQL Azure with Backup from Red-Gate


Last week I finally got round to trying out the beta of a new tool from Red-Gate software – SQL Azure Backup. It is an example of one of those tools that just makes you smile – small download, no install, works as advertised and even has a little “character” Smile

It can backup to SQL Server or to Windows Azure Blob Storage using Microsoft’s Import/Export Service.

Step 1: Enter your SQL Azure Details

image

Step 2: Enter details of the target – in this case a local SQL Express

image

Step 3: Make a cup of tea 🙂

image

OR – watch what is happening. It creates a new db in SQL Azure for transactional consistency

image

Which then gets the schema and data

image

Which is ultimately deleted

image

Step 4: Backup is complete

image

Step 5: And the target database is ready

image

Related Links

Advertisements

One thought on “Backing up SQL Azure with Backup from Red-Gate

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s