Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Locations tab of the SQL Safe Backup wizard allows you to specify the backup location you want to use to store the backup set.

For a TSM backupTSM backup, you can change the TSM connections TSM connection settings to override the values set in the client options file if you need to write the backup files to a TSM Server TSM Server other than the TSM Server 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.
  • S3 Compatible Storage.
  • Microsoft Azure Cloud.
  • Tape (using Tivoli Storage Manager).
  • Tape (using Tivoli Storage Manager) Striped Files.

...

Location TypeActions
Single FileEnter the filename of the primary archive and select if you want to mirror archives.
Striped FilesEnter 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 DomainEnter the filename of the primary archive and select if you want to mirror archives.
Amazon S3 CloudSpecify your Amazon S3 Cloud storage options to be used for your backup. For more information, go to Amazon Settings.
S3 Compatible StorageSpecify your S3 Compatible Storage information for your backup. For more information, go to Cloud 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 striped files you want to backup.

Note

If the number of stripes is greater than the available sessions on the TSM server, the backup fails with a message "sessions are not available on TSM". There is no available way for the TSM client to find out available sessions on the TSM server.

Anchor
striped files
striped files
What are striped files?

...

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 it 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, that 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?

...

If you want to stop the backup operation when the mirror location is unavailable, select the the Abort backup if a mirror location reports a failure.

...

  • High Level file path.
  • Low Level file path.
  • Management Class (optional).
  • the location of the TSM Client options file that enables generate password generating passwords for authorization.

You can change the TSM connections 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.

Tip

Note that SQL Safe accepts up to 260 characters for the TSM file TSM file path name.

Can you store backup files in a different TSM Client file space?

...

When the Amazon S3 Cloud location is selected, you must specify the following settings:

  • Access Key.
  • Secret Key.
  • RegionFilename.
  • Bucket Name.
  • Subfolder(s) (Optional).
  • Filename.
  • Storage Class.
  • Part Size.

For more information, go to Amazon Settings.

Anchor
S3Compatible
S3Compatible
What do you specify when backing up to an S3 Compatible Storage?

When the S3 Compatible Storage location is selected, you must specify the following settings:

  • Access Key.
  • Secret Key.
  • Access Key.
  • File Size.
  • .
  • REST Endpoint (IP: Port).
  • Signature.
  • Bucket Name.
  • Subfolder(s) (Optional).
  • Filename.
  • Part SizeRegion.

For more information, go to Cloud S3 Compatible Settings.

Anchor
azure
azure
What do you specify when backing up to Microsoft Azure Cloud?

When the Microsoft Azure location is selected, you must specify the following settings:

  • Filename.
  • Container NameAuthentication Method.
  • Azure Storage Account Name.
  • Azure Access Key.
  • Sector Type.
  • Container Name.
  • Subfolder(s) (Optional).
  • Filename.
  • Part Size.

For more information, go to Azure Settings.

Once you select the location of your backup files, click NEXT to configure options for your backup. 



SQL Safe Backup hands-free backup and instant recovery across your SQL Servers.
Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse