...
| Warning |
|---|
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 or take note of the password you select. |
What additional options are available?
For each type of backup you select (.safe or .bak), you can also specify the following advanced options, notice that some options are not available depending on the type of backup you selected:
SQL Safe Backup provides additional options that can be applied to SQL Safe Backup Policies. The available options, which are listed below, are dependent on the backup format (SQL Safe or SQL Server) chosen on the General screen.
Options | SQL Safe | SQL Server |
|---|
| .safe | .bak | Description |
|---|
| Use compression | Not available | Available | - You designate the compression rate necessary to match your storage needs.
- Select the level of encryption you need to ensure data security within your environment.
|
| Verify the integrity of the backup when complete | Available | Available | - Verifies the integrity of the backup set data files 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. This option is selected by default.
- 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 it should 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
|
creation |
| Include database logins in 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.
|
Checksum: Generate | Available | Available | - Generates a checksum for the backup file.
- It must be enabled to allow the Checksum: Ignore Errors availability.
|
Checksum: Ignore Errors | Available |
Not available | | Available | - If the Checksum: Generate option is enabled, then either format is available.
|
Not available- If checksum errors are encountered, this option determines that SQL Safe should continue to backup process.
|
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.
- Allows 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.
- 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.
|
After defining your setting in this tab, click Next to Select your backup locations.
...