Configure options

The Options tab of the SQL Safe Backup Policy Wizard allows you to enter the backup types and options for each operation included in 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, or Log. 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?

None
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?

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 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:

Options	SQL Safe	SQL Server	Description
Compression	Available	Available	You designate the compression rate necessary to match your storage needs.
Encryption	Available	Not available	Select the level of encryption you need to ensure data security within your environment.
Pre/Post-Backup Commands	Available	Available	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 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.
Verify the integrity of the backup when complete	Available	Available	Performs a data integrity check after the backup is created. SQL Safe verifies the integrity of the data files in the backup set created by this backup. Verifying the backup helps identify potential issues that could occur when restoring these data files.
Generate maps	Available	Not available	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 objects using SQL virtual database. This option is selected by default.
Report T-Log operations that are skipped as SUCCESS	Available	Available	Allows SQL Safe to report SKIPPED T-Log operations as SUCCESS. Avoids backup policies from reporting a warning status when T-Log operations are skipped for databases that are in simple recovery.
Include database logins in the backup file	Available	Not available	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.
Thread Count	Available	Not available	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. When the resultant backup file is restored, SQL Safe uses the same thread setting to ensure consistent performance. Select Auto to have SQL Safe determine the optimal thread count for your environment.
Transaction Log	Available	Available	Removes all completed transactions, inactive entries, from the transaction log after SQL Safe finishes the backup.
Checksum: Generate	Available	Available	Generates a checksum for the backup file.
Checksum: Ignore Errors	Available	Available	Ignores any errors from the generated checksum. If checksum errors are encountered, this option indicates that SQL Safe should continue to back up this database.
Backup: Copy only	Available	Available	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 interfering the LSN (log sequence number) order of your backup strategy.
Backup: Read-write filegroups	Available	Available	Specifies a partial backup, which includes the primary filegroup and any read-write secondary filegroups. Read-write filegroups are not supported by SQL virtual database. If this option is selected, the Generate metadata option (Generate maps for InstantRestore and SQL virtual database) will be disabled. Backups created with the read-write filegroups option cannot be used by SQL virtual database to create virtual databases.

Once you configure options for your backup, click NEXT to select your backup location.

Content

Space Tools