SQL Server 2014 for backups
What has SQL Server 2014 brought in terms of value for the backup segment? Here is a shortlist with the improvements known.
SQL Server backup to URL
This is a feature that is present since SQL Server 2012 SP1 Cumulative Update 2 (CU2), but it was only supported through T-SQL Scripts, PowerShell, and SMOs (SQL Server Management Objects).
In SQL Server 2014 you can now use the visual interface of SSMS (SQL Server Management Studio) to do a backup or a restore from Windows’s Azure Blob storage. This new option can be accessed through both the standard Backup task or through a Maintenance Plan.
SQL Server Managed Backup to Azure
This feature is actually built on top of Backup to URL and this is a service that SQL Server provides in order to be able to manage and schedule two types of backups, database, and log backups.
In CTP2 only the backup to Azure storage is supported and can be configured at both database and instance level which will allow you to have a granular control at the database level and also be able to automate on the instance level.
You can also configure SQL Server Managed Backup to Windows Azure on instances that run on-premises and instances which run on Azure virtual machines.
Encryption for backups
Now you have the possibility to encrypt the backup file during the backup operation. This feature now supports multiple encryption algorithms which include AES 128, AES 192, AES 256, and Triple DES.
You will have to use either a certificate or an asymmetric key in order to perform encryption during the backup process.
There are also other improvements that SQL Server 2014 will bring to the public and you can find a list of other improvements here.