Home > Windows & SQL Server AZURE > Encrypt SQL Server database backup using Microsoft Azure®Tool

Encrypt SQL Server database backup using Microsoft Azure®Tool

 

Download Microsoft® SQL Server® Backup to Microsoft Azure®Tool and install it on the server where you want to encrypt database back.

 

Download link : http://www.microsoft.com/en-sg/download/details.aspx?id=40740

 

After the installation is successfully navigate to services.msc (Microsoft SQL Server backup to Windows Azure Tool) Service.The service installs with a default login , change it to the correct user and start the service.

 

image

 

Browse the tool from Start (Programs)

image

 

Lets Configure the Tool

 

image

 

Click Add

 

Specify the backup location or all paths.Lets specify a path for demo

image

 

Click Next and choose option local storage

image

 

Click Next  (Currently AES-256 Encryption is available with/without Compression) and click Finish.

 

image

 

To test , lets run the backup from SQL Server Management Studio, You don’t need to do any configuration changes in SQL Server Configuration.

If the backup is in single file , single encrypted file will be generated, if backup is done in multiple stripes , encryption will happen for each file as backup progresses.

 

image

 

image

  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: