Versions Compared

Key

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

SQL Safe allows you to modify many any of the default settings of the application, and you can change your your Management Console Preferences at any time. To access this option, go to the Tools Menu menu and select the respective option. The window for Management Console Preferences allows you to modify settings in the following categories:

...

On the Backup tab, you can set the default parameters that appear on the Backup Wizard. Set the default parameters to the values you typically use. If you want to use different settings on any given backup, you can still make changes on to the wizard itself.

The parameters you can set include the following:

...

Anchor
agent
agent
What Agent Deployment settings can you change?

On the Agent Deployment tab tab, you can identify the service account used to run the agents. You can also choose whether or not you want to automatically upgrade the Backup Agents and the XSP if you upgrade to a new SQL Safe version.

...

Anchor
policy
policy
What Policy Data settings can you change?

On the Policy Data tab tab, you can define the location of your policy data files.

...

  • Specify the Access and Secret Key of your cloud credentials.
  • Select the Region where your information will be stored.
  • Set the Bucket Name where your backup will be stored.
  • Set the SubFolder(s) (Optional) where your backup will be stored or restored from. Consider the following situations:
    • If the SubFolder field is left empty, the backup file will be saved in the root of the specified container.
    • If the SubFolder field is populated with the name of a folder that does not exist on the storage container \ bucket, the folder will be created and the backup file will be saved to the specified Subfolder.
    • Multiple SubFolders can be specified by separating each folder with a forward slash: MyFolder/MySubfolder/MyNestedFolder.
    • The SubFolder field can contain static values as well as tokens like %instance%, %database%, %backuptype%, %policyguid%,and %timestamp%.
  • Specify the Part Size in megabytes of the backup file that will be sent to the bucket simultaneously.
Info

The minimal value for File Size is 10 MB. (1,000,000 bytes).

  • Specify the Temporary Download Location to improve resiliency and performance when downloading large backup files from Amazon S3 Cloud Storage. This location will be displayed when the "Download File from Cloud" option is checked in a restore wizard or restore policy.
Tip

When Amazon cloud settings are set in the preferences Management Console Preferences, they can be used in backup and restore operations.

Anchor
azure
azure
What Azure Settings can you change?

On the Azure Settings tab, you can:

  • Specify the name of the Azure Container where the new blob will be created and the backup stored.
  • Specify the Azure Storage Account Name and Access Key.
  • Set the SubFolderWhen performing backup and restore operations, you will see the option to specify Subfolder(s) (optional) if you want to save Optional) where your backup file or restore it from therewill be stored or restored from. Consider the following situations:
    • If the Subfolder SubFolder field is left empty, the backup file will be saved in the root of the specified container.
    • If the Subfolder SubFolder field is populated with the name of a folder which that does not exist on the storage container \ bucket, the folder will be created and the backup file will be saved to the specified Subfolder.
    • Multiple Subfolders SubFolders can be specified by separating each folder with a forward slash: MyFolder/MySubfolder/MyNestedFolder.

...

    • The SubFolder field can contain static values as well as tokens like %instance%, %database%, %backuptype%, %policyguid%,and %timestamp%.

...

On the Azure Settings tab, you can:

  • Specify the name of the Azure Container where the new blob will be created and the backup stored.
  • Specify the Azure Storage Account Name and Access Key.
  • Define the Azure Sector Type:
    • Public - commercial cloud storage solution.
    • Government - cloud storage solution offered to US government customers and their partners.
  • Specify the Part Size in megabytes of the backup file that will be sent to the bucket simultaneously.
Info

The minimal value for File Size is 10 MB. (1,000,000 bytes).

  • Specify the Temporary Download Location to improve resiliency and performance when downloading large backup files from Microsoft Azure Blob Storage. This location will be displayed when the "Download File from Cloud" option is checked in a restore wizard or restore policy.
Tip

When Azure settings are set in the preferences Management Console Preferences, they can be used in backup and restore operations.

...