Blob storage is a type of Azure storage service. Blob Storage stores file data. A blob can be any type of text or binary data, such as a document, media file, or application installer. You can use Blob storage to store content such as backups of files, computers, databases, and devices. Blob storage is also referred to as Object storage.
Use the Azure Settings tab of the Configure General Preferences option from the Administration tab to specify the storage settings to be used through the different backups and restores.
In these settings you can specify the following fields:
By default, SQL Safe Backup splits the backup into several files, each with size of 70MB.
You can configure the file size by updating the Windows Registry on the machine hosting the SQL Safe Backup Agent using the following steps:
If there are network connection problems, the backup eventually fails, but files remain on Windows Azure. SQL Safe will not delete these partial backup files. If you want to delete those, you need to do it manually on your Azure account.
If the backup fails before creating all blobs and only a couple of blobs are created, these blobs will remain in the container unless you manually delete them.
Take into account that if you do not enable the network resiliency settings for your backup operations and the network goes down, the operation fails and no retry is executed. When enabling the network resiliency settings and using Azure Blob for backup operations, only the following parameters are applicable:
In restore operations, the resiliency settings remain enabled.
Take into account the following naming conventions for your container:
Take into account the following blob naming rules:
A blob name can contain any combination of characters.
A blob name must be at least one character long and cannot be more than 1,024 characters long.
Blob names are case-sensitive.
The number of subfolders cannot exceed 254.
Avoid filenames that end with a dot (.), a forward slash (/), or a sequence or combination of the two.
The Microsoft Azure Blob service is based on a flat storage scheme, not a hierarchical scheme. However, SQL Safe allows you to specify subfolders which act as a virtual hierarchy. If you store a large number of blobs in your Azure container then it is recommended to utilize subfolders to improve SQL Safe performance.