SQL Backup to Blob Storage Folders

We have a blob storage for all our servers, and I linked one of our server to that Blob Storage. What I discovered that, the folders I can't assign each database backup to a different folder in Blob Storage. Than means I can't use a Cloud Storage Settings to set different backup to different folders. Is this a future missing or am I missing some functionality.
Tagged:

Answers

  • Eddie DEddie D Posts: 1,778 Rose Gold 5
    Hi, thank you for your forum post.

    No you are not missing functionality.  When support for Azure Blob Storage was added to SQL Backup V10, the ability to select a folder was omitted, which means users cannot set different backup sets to different folders with the Azure storage.

    Also if manually scripting backup jobs, the HOSTED_FOLDER and HOSTED_TAGS keywords should not be used if the your cloud storage is Azure (It is only supported if using AWS S3 bucket).

    I recommend that you vote and comment on this SQL Backup UserVoice topic.

    In the short to medium term there are no plans to add Azure Storage to the HOSTED_FOLDER and HOSTED_TAGS keywords.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.