Home > Azure, SQL > Microsoft® SQL Server® Backup to Microsoft Windows® Azure®Tool

Microsoft® SQL Server® Backup to Microsoft Windows® Azure®Tool

Microsoft SQL Server Backup to Windows Azure Tool enables backup to Windows Azure Blob Storage and encrypts and compresses SQL Server backups stored locally or in the cloud.

SQL Server 2012 and SQL Server 2014 have built in capability to back up to Windows Azure storage. The SQL Server Backup to Windows Azure tool provides the same functionality to previous versions of SQL Server. It can also be used to specify encryption and compression for your backups.

Using the 3-step wizard, you can specify a rule or set of rules that are applied to any SQL Server backup. One example of a rule could be to redirect all local backups to the specified Windows Azure storage. Another example of a rule would be to use compression or encryption for backups stored in a specific location.

Once you configure the rules, these rules are applied to SQL Server Backup files. If the rule is set to use Windows Azure storage account, the tool redirects the backups to the specified Windows Azure storage account, but leaves a stub file with metadata information to be used during restore.

Benefits:

· Support for backups to Windows Azure Storage for SQL Server versions that do not have the built-in capability. Using Windows Azure storage for your backups has several benefits off-site storage for disaster recovery, ability to access from any location, etc. For more information, see SQL Server Backup and Restore with Windows Azure.

· Encryption and Compress support for SQL Server versions that do not have the built in capability. Currently only SQL Server 2014 has encryption support, and SQL Server 2008 or later support compression during backup. SQL Server 2008 supports compression in Enterprise edition only, but for SQL Server 2008 R2 and later encryption is supported on Standard editions or higher.

 

Download from there

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

Advertisements
Categories: Azure, SQL
  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: