When selecting Data Domain as the backup location, compression and encryption are set to "None" by default. This configuration allows the Database Domain to manage those functions, as recommended by Dell EMC, to get the most benefit from deduplication.
SQL Safe does not support Data Domain Boost (DDBoost) client-side deduplication.
CIFS should be enabled and a share created for the SQL Safe agent to use.
The Data Domain input fields in the Backup Wizard should be the same as the Single File location type. However, when Data Domain is selected, compression and encryption options (on the next tab) are both get set to “None” automatically.
Restore processes will also not change. Data Domain backups can be located in the same way as other network backups, using the Repository or File System tab.
| Location Type | Actions | |
|---|---|---|
| Single File | Enter the 9.4 Data Domain location for manual backup of the primary archive and select if you want to mirror archives. | |
| Striped Files | Enter as many backup archive names as the number of 9.4 Data Domain location for manual backup you want. | |
| Data Domain | Enter the 9.4 Data Domain location for manual backup of the primary archive and select if you want to mirror archives. | |
| Amazon S3 Cloud | Specify your Amazon S3 Cloud storage options to be used for your backup. For more information, go to Amazon Settings. | |
| S3 Compatible Storage | Specify your S3 Compatible Storage information for your backup. For more information, go to S3 Compatible Settings. | |
Microsoft Azure Cloud | Specify your Microsoft Azure cloud storage options to be used for your backup. For more information, go to Azure Settings. | |
| Tape (Tivoli Storage Manager) | Enter the filename for the High Level, Low Level, and Management Class of the primary archive. Specify the TSM Client configuration file and its connection settings. | |
| Tape (using Tivoli Storage Manager) Striped Files | Enter the High Level filename and the Management Class for the primary archive. Specify the TSM Client configuration file and its connection settings. Also, the number of 9.4 Data Domain location for manual backup you want to backup.
|
If you want to take advantage of distributing I/O overhead for a large database, select striped files, and select backup locations on different local disks.
Select Enable network resiliency and click Configure to change the default settings. By default, SQL Safe will retry the backup operation every 10 seconds and then fail after 5 minutes (300 seconds) of continuous errors. Also, over the course of the operation, SQL Safe allows a total of 60 minutes in which to retry the backup before stopping the operation.
| This option is not available when backing up to tape using Tivoli Storage Manager. |
You can Append it to an existing archived backup set or choose to Overwrite it.
If you do not have an existing archive file, SQL Safe creates a new archive file that includes this backup set, using the name you specified.
Keep in mind that the filename extension for all backups performed on SQL Safe format is .safe, and for all backups performed on SQL server format is .bak. |
To specify a UNC path, type the UNC path directly in the Filename field. You cannot specify a UNC path when using thebrowse option.
Using a UNC path allows you to restore backups to a different or new server from the original archive. |
Click Mirror Archives, and specify where you want the mirror copies to be stored.
For each mirror, SQL Safe creates a copy of the backup archive set. You can specify up to 2 mirrors for each backup operation.
| Keep in mind that creating mirrors can impact the performance of your backup operation. |
If you want to stop the backup operation when the mirror location is unavailable, select Abort backup if a mirror location reports a failure.
| This option is only available when backing up to Single File and Data Domain. |
When a TSM location is selected, you must specify the following settings:
You can change the TSM connection settings to override the values set in the client options file. You can also configure SQL Safe to mark these files as inactive after a specified age.
SQL Safe accepts up to 260 characters for the TSM file path name. |
Yes. Under TSM Client Settings, specify the name of the node you want to use and the password required to access the node.
Click Change to specify the node name, the password required to access the node, and the TCP/IP Server address and port.
When the Amazon S3 Cloud location is selected, you must specify the following settings:
For more information, go to Amazon Settings.
When the S3 Compatible Storage location is selected, you must specify the following settings:
For more information, go to S3 Compatible Settings.
When the Microsoft Azure location is selected, you must specify the following settings:
For more information, go to Azure Settings.
Once you select the location of your backup files, click NEXT to configure options for your backup.
|