Perform a database backup with options
In this we will learn how to perform a database backup with options.
However, use the Backup Options page of the Back Up Database dialog box to view or modify database backup options. Further, to create a backup by using SQL Server Management Studio
- Firstly, create a Full Database Backup (SQL Server)
- Secondly, create a Differential Database Backup (SQL Server)
Options
Backup set
The options of the Backup set panel allow for you to specify optional information about the backup set created by the back up operation.
Name
Specify the backup set name. However, here, the system automatically suggests a default name based on the database name and the backup type.
Description
Enter a description of the backup set.
Backup set will expire
Choose one of the following expiration options. However, this option is disabled if URL is chosen as the backup destination.
After
Specify the number of days that must elapse before this backup set expires and can be overwritten. However, this value can be from 0 to 99999 days. And, a value of 0 days means that the backup set will never expire.
Further, 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.
On
Specify a specific date when the backup set expires and can be overwritten.
Encryption
To create an encrypted backup, check the Encrypt backup check box. After that, select an encryption algorithm to use for the encryption step. Then, provide a Certificate or Asymmetric key from a list of existing certificates or asymmetric keys. However, the available algorithms for encryption are:
- Firstly, AES 128
- Secondly, AES 192
- Then, AES 256
- Lastly, Triple DES
Reference: Microsoft Documentation