The Options tab of the SQL Safe Backup wizard allows you to select additional options, such as compression and encryption, to use for the current backup operation.
What types of compression algorithms are available?
- None.
- IntelliCompress, optimize for size (iSize).
- IntelliCompress, optimize for speed (iSpeed).
- Levels 1, 2, 3, 4.
| Tip |
|---|
A backup operation using Level 1 completes fastest but achieves 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 how to choose compression and encryption.
| Tip |
|---|
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?
- None.
- AES (128-bit).
- AES (256-bit).
If your SQL Server environment requires FIPS compliance, use the AES encryption option. For more information, see Ensure ensure FIPS compliance.
| Tip |
|---|
When performing a backup on a SQL Server format, the encryption option is not available. |
Does encryption require a password?
...
| Options | Description |
|---|
| Number of threads | Allows you to specify how many threads you want SQL Safe to use to distribute the backup operation across multiple processors on the target SQL Server computer. Use this setting to optimize backup performance. Select Auto to have SQL Safe determine the optimal thread count for your environment. |
| Pre/Post-Backup Commands | Allows you to specify commands you want to execute before and/or after the backup completes. Select Configure.. to determine the commands you want to run. Click on  Image Added to add the cmd file. You can also select to Quit backup job if the pre-backup command fails. Yes is the default. The command can be a script or a user executable, non-interactive program. It should be located on a UNC path. |
| Remove inactive transaction log entries | Removes all completed transactions from the transaction log after SQL Safe finishes the backup. This option is only available for Log backups. |
| Generate maps | Generates maps containing metadata for each database included in your backup file. Depending on the number of transactions completed since your last backup, generating maps may impact the performance of the backup operation. Generating maps is optional, but must exist in the backup file for InstantRestore to accept and restore that file. SQL virtual database can attach SQL Safe backup files without the metadata, but the data files improve SQL vdb performance during the creation of the virtual database. For more information, see Recover recover objects using SQL virtual database. This option is selected by default. |
| Include database logins in the backup file | Copies SQL login information for the selected databases, including credentials and privileges, when the backup files are written. To help ensure the security of your SQL Server database, SQL Safe encrypts the login information. This option is available for full backups only. |
| Tip |
|---|
When performing a backup on a SQL Server format, some advanced options are not available for this type of format. |
What are the advanced options for SQL Server 2005 and later?
...
You can generate a T-SQL or CLI script that will execute the backup you have defined in the wizard. For more information about generating scripts, see How how script generation works.
What do you do next?
After you complete the Options tab, you can click Next to continue with the Backup Wizard, select any previously visited tab to modify that information, or click Generate Script to create a T-SQL or CLI scriptOnce you configure the options for your backup, click NEXT to configure notifications.