Page History
The The Locations section of the Backup wizard Wizard allows you to specify the backup location you want to use to store the backup set.
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.
Where can you store your backup set?
SQL Safe supports the following location types:
- Single File.
- Striped Files.
- Tape (Tivoli Storage Manager).
- Data Domain.
- Amazon S3 Cloud.
- Microsoft Azure Cloud.
- Tape (Tivoli Storage Manager) Striped Files
What do you do if you do have an existing archive?
...
- .
What
...
If you do not have an existing archive file, SQL Safe creates a new archive file to include the backup set.
What actions do you have for each location type?
Location Type | Actions |
---|---|
Single File |
|
Striped Files |
|
Tape (Tivoli Storage Manager) |
|
|
| |
Data Domain |
|
| |
Amazon S3 Cloud |
|
|
Microsoft Azure Cloud |
|
|
|
| |
Tape (Tivoli Storage Manager) Striped Files |
|
|
|
|
|
What are striped files?
If you want to take advantage of distributing I/O overhead for a large database, you can select striped files and choose backup locations on different local disks.
When backing up SQL Server 2000 databases, consider using as few striped files as possible since a high number of striped files can significantly degrade performance due to SQL Server memory allocation.
How do you handle errors encountered while writing to the network during a backup?
Select Enable Enable Network Resiliency and access the the Network Resiliency Settings window where you can specify how often you want to retry when errors occur and after how much time the operation will fail. You can also configure how much time is allowed for the total retry time of the backup.
Info |
---|
This option is not available when backing up to tape using Tivoli Storage Manager. |
What do you do if you do have an existing archive?
If the Archive Exist, you can select to Append it to an existing archived backup set or choose to Overwrite it.
What happens if you do not have an existing archive file?
If you do not have an existing archive file, SQL Safe Backup creates a new archive file to include the backup set.
Tip |
---|
Keep in mind, the filename extension for all backups performed under the SQL Safe format are .safe and for all backups performed under the SQL server format are .bak. |
How do you mirror your backups?
Mirroring your backups is available when you select Single File or Data Domain location type. Select Select Mirror Archives, then specify where you want the mirror copies to be stored.
...
If you want to stop the backup operation when the mirror location is unavailable, select select Abort backup if a mirror location reports a failure.
Info |
---|
This option is only available when backing up to Single File and Data Domain. |
Once you select After selecting the location of your backup files, go to the Configuring click NEXT to configure options for your backup section.
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
...
...