Search This Blog

Wednesday, October 21, 2015

Backup Database to Azure for Older Version of SQL Server

 

Learned new stuff today when attending Cloud Platform University on Selling Azure and SQL Server for Business Continuity course.

image

As we understand SQL 2012 or 2014 allow you to backup to disk and tape as well as Microsoft Azure Storage.


You can use T-SQL or SQL 2012+ using SQL Server Management Studio. So how to backup prior version of SQL Server?

The answer is free “SQL Server Backup to Microsoft Azure Tool” enables an Azure-based backup strategy by supporting older versions of SQL Server (2005 - 2012).  You can also incorporate encryption and compression for your backups – even for versions of SQL Server that don’t support these functions natively.

[ Pre-requisite ]
1. Create Azure Blob Storage Container

2. Only SQL version from 2005 or later

3. OS – Windows Server 2008 or higher, Windows 7 or later client operating system.

[ Configuration]
1.Download Microsoft SQL Server Backup to Microsoft Azure Tool from
http://www.microsoft.com/en-gb/download/details.aspx?id=40740
2. Use SQL Management Studio to configure backup first.
3. Use SQL Server Backup to Microsoft Azure Tool to get the SQL backup (*.bak) and transfer to Azure Storage.

image

4.Next step, specify the Azure Storage account that you’ve created on pre-requisite requirement.

image

5. Then you can  either specify or not to include encryption & compression.

image

image

You will see a process “SQL Backup2Azure Service is exist on task manager.

image

Finally, you’ve successful created a rule that will redirect all local backups to the specified Windows Azure Storage when SQL Server has completed the backup process.