

For example, the following example configures the MyDB database for encryption using a certificate named MyTestDBBackupEncryptCert and the AES_128 encryption algorithm. Set Managed Backup Encryption: Call the managed_backup.sp_backup_config_advanced stored procedure with the corresponding values. WITH SUBJECT = 'MyTestDBBackupEncryptCert'

USE Master ĬREATE CERTIFICATE MyTestDBBackupEncryptCert The following example creates a backup certificate to use for the encryption. The key is encrypted using the password ""ĬREATE MASTER KEY ENCRYPTION BY PASSWORD = '' Ĭreate a Backup Certificate or Asymmetric Key: You can use either a certificate or an asymmetric key for use with the encryption. Select from one of the following algorithms.Ĭreate a Database Master Key: Choose a password for encrypting the copy of the master key that will be stored in the database.
#Sql backup schedule how to
The following steps describe how to specify encryption settings using the stored procedure managed_backup.sp_backup_config_advanced (Transact-SQL).ĭetermine the Encryption Algorithm: First determine the name of the encryption algorithm to use. Otherwise, it is possible that unwanted backup operations will occur during the window of time between enabling SQL Server Managed Backup to Microsoft Azure and configuring these settings. You should always configure the advanced options and custom scheduling options before enabling SQL Server Managed Backup to Microsoft Azure with managed_backup.sp_backup_config_basic (Transact-SQL).
