Page History
...
The following options are available as Advanced Options:
| Options | .safe | .bak | Description |
|---|---|---|---|
| Number of threads | Available | Not Available | Allows you to specify how many threads you want SQL Safe to use to distribute the backup operation for compression 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. |
| Remove inactive transaction log entries | Not Available | Not Available | Removes all completed transactions from the transaction log after SQL Safe finishes the backup. This option is only available for Log backups. |
| Generate maps (for InstantRestore and SQL virtual database) | 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 VDB performance during creation of the virtual database. For more information, see Recover objects using SQL virtual database. This option is selected by default. |
| 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. |
...