The Options tab of the SQL Safe Backup Policy Wizard allows you to enter the backup types and options for each operation included the backup policy.
What information is on this tab?
For each backup operation you include in the backup policy, you can select compression, encryption, and verification options, enable object-level recovery, and set additional advanced options such as removing inactive entries from the transaction log.
What types of backup can you choose?
On the Options tab you can choose the types of backups you want for your backup policy. You can specify one, two or the three types of backup: Full, Differential, Log, just select the respective backup types and provide their settings.
Why can't you see the options for all the backup types?
The options for each backup type are hidden unless the backup type is selected for the policy. For more information about backup types, see understand backup types.
What types of compression algorithms are available?
- IntelliCompress, optimize for size (iSize)
- IntelliCompress, optimize for speed (iSpeed)
- Levels 1, 2, 3, 4
Backup operations using Level 1 complete fastest but achieve the least amount of compression. Level 4 achieves maximum compression but the backup operation may take longer.
For more information about backup compression, see how to choose compression and encryption.
When performing a backup on a SQL Server format, the compression options available are: none and compress backup.
What types of encryption algorithms are available?
- AES (128-bit)
- AES (256-bit)
If your SQL Server environment requires FIPS compliance , use the AES encryption option. For more information, see ensure FIPS compliance.
When you choose to encrypt an archive, you must designate a password. For security reasons, SQL Safe does not store this password. Ensure you remember the password you select.
When performing a backup on a SQL Server format, the encryption option is not available.
What additional options are available?
For each type of backup you select, you can also specify the following advanced options:
|Verify the integrity of the backup when complete||Available||Available|
|Generate maps||Available||Not available|
|Report T-Log operations that are skipped as SUCCESS||Available||Available|
|Include database logins in backup file||Available||Not available|
Checksum: Ignore Errors
Backup: Copy only
Specifies a copy-only backup. This is a copy of the database and cannot be used as part of a restore strategy. It will allow you to take a "snapshot" backup of your database without interferring the LSN (log sequence number) order of your backup strategy.
Backup: Read-write filegroups
Once you configure options for your backup, click NEXT to select your backup location.