When you specify a backup task by using SQL Server Management Studio, you can generate the corresponding Transact-SQL BACKUP script by clicking the Script button and then selecting a destination for the script.
Choose one of the following expiration options. This option is disabled if URL is chosen as the backup destination.
Specify the number of days that must elapse before this backup set expires and can be overwritten. This value can be from 0 to 99999 days; a value of 0 days means that the backup set will never expire.
The default value for backup expiration is the value set in the Default backup media retention (in days) option. To access this, right-click the server name in Object Explorer and select Properties; then click the Database Settings page of the Server Properties dialog box.
Specify a specific date when the backup set expires and can be overwritten.
Click to create an uncompressed backup, regardless of the server-level default.
To create an encrypted backup, check the Encrypt backup check box. Select an encryption algorithm to use for the encryption step, and provide a Certificate or Asymmetric key from a list of existing certificates or asymmetric keys. The available algorithms for encryption are:
The encryption option is disabled if you selected to append to existing backup set.
It is recommended practice to back up your certificate or keys and store them in a different location than the backup you encrypted.
Only keys residing in the Extensible Key Management (EKM) are supported.