Versions Compared

Key

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

...

  • Back up to a single file on the local computer or a network share
  • Back up to multiple striped files on the local computer or a network share
  • Back up to tape using Tivoli Storage Manager
  • Back up to Data Domain 
  • Back up to Amazon S3 Cloud
  • Back up to Microsoft Azure Cloud
  • Back up to tape using Tivoli Storage Manager Striped Files 

What do you do if you do not have an existing archive?

...

When a TSM location is selected, you have to specify the following settings:

  • The location of the TSM Client configuration file
  • High level file path
  • Low level file path
  • Management Class

You can also configure SQL Safe to mark these files as inactive after a specified age.

Warning

SQL virtual database is not available when backing up to a TSM Server.

How do you backup to multiple stripes using TSM Servers?

You can also back up to tape using Tivoli Storage Manager Striped Files. If you select this option, provide the following information:

  • The location of the TSM Client configuration

...

  • file
  • High level file path
  • Management class
  • The number of striped archives to use and the respective names for each low level file name

You can also configure SQL Safe to mark these files as inactive after a specified age.

...

Note

Take into account:

  • If the number of stripes is greater than the available sessions on 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.
  • If a password is required for TSM, then policies created using TSM may not work correctly
Warning
SQL virtual database is not available when backing up to a TSM Server
  • .

What do you specify when backing up to Amazon S3 Cloud?

When Amazon S3 Cloud backup location is selected, you have to specify the following fields:

  • Append/Overwrite - select if you want to append the backup archive to an existing one or if you prefer to overwrite it. 
  • Bucket Name - define the name of the Amazon S3 bucket where your backup will be stored
  • Secret Key - specify the secret key generated in your security credentials of your Amazon S3 web console. For more information, click
    Newtablink
    aliashere
    urlhttp://docs.aws.amazon.com/general/latest/gr/managing-aws-access-keys.html
  • Access Key specify the access key generated in your security credentials of your Amazon S3 web console.  For more information, click
    Newtablink
    aliashere.
    urlhttp://docs.aws.amazon.com/general/latest/gr/managing-aws-access-keys.html
  • File size - File size is used to determine the minimal parts of the backup file in bytes that will be sent to the bucket simultaneously. The minimal value for File Size is 1 000 000 bytes. Note that when backing up to a cloud location, the network quality may affect performance. 
  • Region - select the region where your information will be stored. You can find more information about these regions
    Newtablink
    aliashere.
    urlhttp://docs.aws.amazon.com/general/latest/gr/rande.html#s3_region
     
  • Filename - specify the name with which your information will be stored

What do you specify when backing up to Microsoft Azure Storage?

When Microsoft Azure Storage is selected, make sure you specify the following fields:

  • Container name   - the name of the Azure container where your backup will be stored. Every blob in Microsoft Azure storage must reside in a container. The container forms part of the blob name. For more information, click
    Newtablink
    aliashere.
    urlhttps://azure.microsoft.com/en-us/documentation/articles/storage-dotnet-how-to-use-blobs/#create-a-container
     
  • Azure Storage Account Name - the account name of your storage account. Every object you store in Azure Storage has a unique URL address. The storage account name forms the subdomain of that address. You can find more information in the following 
    Newtablink
    aliaslink.
    urlhttps://azure.microsoft.com/en-us/documentation/articles/storage-create-storage-account/#storage-account-endpoints
  • Azure Access Key - the access key to your Azure Storage Account. For more information about Azure Keys, click 
    Newtablink
    aliashere.
    urlhttps://azure.microsoft.com/en-us/documentation/articles/storage-create-storage-account/#view-and-copy-storage-access-keys
  • Filename - to be used as your primary backup archive

After defining your setting in this tab, click Next to Configure the schedule of your backup operations

...

SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >

...