

#SQL SERVER VDI AND COMPRESSION TDE WINDOWS 7#
This tool is supported on SQL Server 2005 or later, and Operating System versions: Windows Server 2008 or later for Servers, and Windows 7 or later for Client Operating Systems. SQL Server and Operating Systems Support: Currently, SQL Server 2008 supports compression in Enterprise edition only, but SQL Server 2008 R2 and later, encryption is supported on Enterprise and Standard editions. Compression support for SQL Server versions that do not have the built in capability.Currently only SQL Server 2014 has encryption support. Encryption support for SQL Server versions that do not have the built in capability.For more information, see SQL Server Backup and Restore with Microsoft Azure. Using Microsoft Azure storage for your backups has several benefits, such as providing off-site storage for disaster recovery, accessibility regardless of location, etc. Support for backups to Microsoft Azure Storage for SQL Server versions that do not have the built-in capability.If the rule is set to use a Microsoft Azure storage account, the tool redirects the backups to the specified Microsoft Azure storage account, but leaves a stub file in the local storage with metadata information to be used during restore. Once you configure the rules, these rules are applied to SQL Server Backup files.

Another example of a rule would be to use compression or encryption for backups stored in a specific location. One example of a rule could be to redirect all local backups to the specified Microsoft Azure storage. Using the 3-step wizard, you can specify a rule or set of rules that are applied to any SQL Server backup. It can also be used to provide encryption and compression for your backups. The SQL Server Backup to Microsoft Azure tool provides the same functionality for previous versions of SQL Server. SQL Server 2012 SP1 CU2 and SQL Server 2014 have built in capability to back up to Microsoft Azure storage. Microsoft SQL Server Backup to Microsoft Azure Tool
