To configure the backup settings you want to use by default for all your backup jobs, go to the Backup Preferences tab of the Configure General Preferences option from the Administration tab.
In this tab you can set the following preferences:
Where to access backup archives on file system
Use this section to configure:
- File System location - define the path where backup archives are located. By default, C:\Backup\ is used as the File System location. You can type a different path.
- Retry writing backup files after network errors - select this option if you want to retry writing backup files after network errors. Click Configure to specify retry settings such as the interval between each retry or how long SQL Safe will wait until it fails the operation.
Where to access backup archives on Tivoli Storage Manager
In this section you can configure the High level, Low Level, and the path where to find the Configuration File for TSM. To change any of these settings, type directly into the box field.
How to store backup archives
In this section you can configure or select the following options:
- If archive exists – use this option to define what to do if the archive already exists. You can Append to an existing archived backup set or choose to Overwrite it.
- Compression - use this option to specify your compression level (iSpeed, iSize, Level1, Level2, Level3 or Level4). Go to Understand compression levels to know what each level of compression entices.
- Encryption - select what type of encryption you want to use. Go to Understand encryption levels to know what each level of encryption means.
- Generate metadata for quick access by SQL Virtual Database
- Include database logins in backup file
What format to use to generate default file names
SQL Safe allows you to define what format you want to use for generating backup file names. You have two box fields in this section:
- Use the following template - In this box field, click the place where you want to add syntax for your backup file name, then click Insert. You can select from Backup Type, Database Name, Instance Name, Stripe Ordinal, Stripe Total, Timestamp, or UTC Timestamp and the format will be inserted in the location selected. Use the option Reset to get back to a previous configuration.
- Preview - SQL Safe displays the format settings specified in the previous field.
Tune Performance
In this section you can specify the number of threads SQL Safe will use when performing a single archive backup. You can set it to Auto, 1, 2, 28, etc.