Back Up Database (Backup Options Page)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Use the Backup Options page of the Back Up Database dialog box to view or modify database backup options.
To create a backup by using SQL Server Management Studio
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.
The options of the Backup set panel allow for you to specify optional information about the backup set created by the back up operation.
SQL Server 2008 Enterprise (or a later version) supports backup compression.
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.