SQL Server backup to Azure with Microsoft Azure Tool

Oopps! Upgrade your browser pretty please.Oopps! Upgrade your browser pretty please.

 

 

Start by downloading and installing the SQL Server Backup – Microsoft Azure Tool link
http://www.microsoft.com/en-gb/download/details.aspx?id=40740


When the download and installation is complete, you can see that Microsoft Azure®Tool runs as a service and it starts automatically

bildasservice

 

 

 

Start the Azure Tool Configuration

startaTool

 

 

 

Create and configure the backup Rule

skaparule

 

 

 

 

Enter the path for the backup

addrule

 

 
Azure Storage Account Name, Access Key and Container

adrule2

 

 

 

 

Encryption if you like, compression is by default

ecrypt

 

 

 

 

Backup Rule is created and points to C:\backup
where the configuration file is created

backupruleskapad

 

 

 

 

Backup of AdventureWorks2008R2

backupadbentureworks2008r2

 

 

 

Specify the folder specified in the back-up Rule

backupsokvag

 

 

 

 

Backup is running

backuprunning

 

 

 

Backup success

backupsuccess

 

 

 

 

In Azure Storage Account container there are now two files.
The AdventureWork2008R2 backup and the configuration file

Azure2008r2backup

 

 

 

 

The configuration file looks like this

lokalbackup

konfigfil

 

 

Backup folder C:\backup can also be used for Maintenance Plans or Hallengrens script, just select the backup folder. Would you also like take transaction log backups just create a backup Rule in the same way.

trnbackup

 

 

Backup with Maintenance Plan

backupsublan

 

 

Result in Azure

Azure2008r2_2

 

 

That’s all for this time, hopefully it has inspired you to test backups with SQL backup to Azure tool.

 

Good luck