Page History
...
For a TSM backup, you can change the TSM connections settings to override the values set in the client options file if you need to write the backup files to a TSM Server other than the TSM Server already specified in the dsm.opt file.
What information is on the Locations tab?
You can select the location type and the UNC or full path of an existing archived backup set.
Where can you store your backup set?
...
- Single File.
- Striped Files.
- Tape (using Tivoli Storage Manager).
- Data Domain.
- Amazon S3 Cloud.
- Microsoft Azure Cloud.
- Tape (using Tivoli Storage Manager) Striped Files.
| Tip |
|---|
When you perform a backup under the SQL Server format (native backup), the following location types are available:
|
What actions can you take with the location types?
| Location Type | Actions | ||
|---|---|---|---|
| Single File | Enter the filename of the primary archive and select if you want to mirror archives. | ||
| Striped Files | Enter as many backup archive names as the number of striped files you want. | ||
| Tape (Tivoli Storage Manager) | Enter the filename for the High Level, Low Level, and the Management Class of the primary archive. Specify the TSM Client configuration file and its connection settings. | ||
| Data Domain | Enter the filename 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. | ||
Microsoft Azure Cloud | Specify your Microsoft Azure cloud storage options to be used for your backup. For more information, go to Azure 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 striped files you want to backup.
|
| Anchor | ||||
|---|---|---|---|---|
|
...
| Info |
|---|
| This option is not available when backing up to tape using Tivoli Storage Manager or Amazon S3 Cloud. |
What do you do if you do have an existing archive?
You can Append to an existing archived backup set or choose to Overwrite it.
What do you do if you do not have an existing archive file?
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.
What do you do if you do have an existing archive?
...
| Tip |
|---|
Keep in mind, the filename extension for all backups performed on SQL Safe format are .safe and for all backups performed on SQL server format are .bak. |
Anchor filename filename
How do you specify a UNC path?
| filename | |
| filename |
...