SQL Server 2014 and Cloud - Getting Started with SQL Server 2014 Administration - page 26

,@storage_url = 'https://gresqlstorage.blob.core.windows.net/'
,@retention_days=5
,@credential_name='AzureCredential'
,@encryption_algorithm =NO_ENCRYPTION
To view the Managed Backup information, you can run the following query:
Use msdb
GO
SELECT * FROM smart_admin.fn_backup_db_config('T3')
The results should look like this:
To disable the Managed Backup, you can use the smart_admin.sp_set_db_backup
procedure to disable it:
Use msdb;
GO
EXEC smart_admin.sp_set_db_backup @database_name='T3'
,@enable_backup=0
Encryption
For the first time in SQL Server, you can encrypt your backups using the native SQL
Server backup tool. In SQL Server 2014, the backup tool supports several encryption
algorithms, including AES 128 , AES 192 , AES 256 , and Triple DES . You will need a
certificate or an asymmetric key when taking encrypted backups. Obviously, there
are a number of benefits to encrypting your SQL Server database backups, including
securing the data in the database. This can also be very useful if you are using
transparent data encryption (TDE) to protect your database's data files. Encryption
is also supported using SQL Server Managed Backup to Microsoft Azure.
Creating an encrypted backup
To create an encrypted SQL Server backup, there are a few prerequisites that you
need to ensure are set up on the SQL Server.