Versions Compared

Key

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

...

For each operation you have included in the backup policy, you can specify the location type, the full path in which to store the backup file, an optional housecleaning schedule for existing disk archives, and the backup file extension.

...

  • Backup to a single file on the local computer or a network share.
  • Backup to multiple striped files on the local computer or a network share.
  • Backup to tape using Tivoli Storage Manager.
  • Backup to Data Domain.
  • Backup to Amazon S3 Cloud.
  • Backup to S3 Compatible Storage.
  • Backup to Microsoft Azure Cloud.
  • Backup to Tape using Tivoli Storage Manager striped files.

...

If you do not specify an existing archive, SQL Safe creates a new backup set with the name you specify. The location entered for each backup type must be valid for all SQL Server instances. You can choose to to Append or Overwrite if the archive already exists.

What accounts can you specify to access the location of the backup files

...

?

Depending on whether you selected to use the SQL Server Agent or the SQL Safe Backup Agent for the scheduling of your policy, on in this section you have the option to select between the SQL Server Agent service account/SQL Safe Backup Agent service account respectively, or a Windows account. Click Click Account and select your preferred option.

...

SQL Safe automatically populates the path using several available variables, depending on the location type. You can modify this path to suit your needs, taking advantage of all the available variables.

...

How do you mirror the backups this policy creates?

Click Mirror Archives , and then specify where you want the mirrored files to be stored.  

...

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

...

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

...

For more information, go to Amazon Settings.

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.
  • REST Endpoint (IP: Port).
  • Bucket Name.
  • Subfolder(s) (Optional).
  • Filename.
  • Part Size.

For more information, go to S3 Compatible Settings.

What do you specify when backing up to Microsoft Azure?

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

  • Authentication Method
  • Azure Storage Account Name
  • Azure Access Key
  • Sector Type
  • Container Name
  • Subfolder(s) (optional)
  • Filename
  • Part Size

...