Page History

...

• Back up to a single file on the local computer or a network share.
• Back up to tape using Tivoli Storage Manager.
• Back up to multiple striped files on the local computer or a network share.
• 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?

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 Append or Overwrite if the archive already exists.

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

...

?

Specify the account to access the filesystem when you select any of the following location types: Single File, Striped files, or Data Domain. Depending on whether you selected the SQL Server Agent or the SQL Safe Backup Agent for your policy, you will be able to choose between SQL Server Agent service account/SQL Safe Backup Agent service account respectively or a Windows account. Click Click Account and select your preferred option.

...

Can you change the default file locations?

...

If you want to stop the backup operation when the mirror location is unavailable, select Abort backup if a mirror location reports a failure. You can also enable to remove files older than a specified time. 

...

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

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

...

• Append/Overwrite - select if you want to append the backup archive to an existing one or if you prefer to overwrite it. 
• Filename - to be used as your primary backup archive.
• Access Key  - specify the access key generated in your the security credentials of your Amazon S3 web console. For more information, click 

  Newtablink
  alias here url http://docs.aws.amazon.com/general/latest/gr/managing-aws-access-keys.html

  .
• Secret Key  - specify the secret key generated in your the security credentials of your Amazon S3 web console. For more information, click 

  Newtablink
  alias here url http://docs.aws.amazon.com/general/latest/gr/managing-aws-access-keys.html

  .
• Region - select the region where your information will be stored. You can find more information about these regions 

  Newtablink
  alias here url http://docs.aws.amazon.com/general/latest/gr/rande.html#s3_region

  .
• Bucket Name - define the name of the Amazon S3 bucket where your backup will be stored.
• SubFolder(s) (Optional) - specify the subfolder(s) where your backup will be stored. 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%.
• 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. 

...

• Container name - the name of the Azure container where your backup will be stored. Every 

  Newtablink
  alias blob url https://azure.microsoft.com/en-us/documentation/articles/storage-dotnet-how-to-use-blobs/#what-is-blob-storage

   in Microsoft Azure storage must reside in a container. The container forms part of the blob name. For more information, click 

  Newtablink
  alias here url https://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
  alias link url https://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
  alias here url https://azure.microsoft.com/en-us/documentation/articles/storage-create-storage-account/#view-and-copy-storage-access-keys

  .
• SubFolder(s) (Optional) - specify the subfolder(s) where your backup will be stored. 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%.
• Sector Type - define the Azure sector type:
  • Public - commercial cloud storage solution.
  • Government - cloud storage solution offered to US government customers and their partners.

• Enable Network Resiliency - enable or disable the network resiliency settings for your backup operations. You can click on Configure to define how to handle errors encountered while writing to the network during a backup.

• Filename - to be used as your primary backup archive.

...