It is always fun to work with “Backup to URL” feature of SQL Server. The error messages which are raised are from Azure storage side and an SQLDBA won’t be able to understand the meaning. While I was working with my VM to learn something about Backup to URL feature, I realized that my backups were failing. In this blog, let us learn how to fix the back to URL error: Operating system error 50(The request is not supported.). Here are the exact messages which I was getting in ERRORLOG.
SQL SERVER – Backup to URL – Script to Generate Credential and Backup using Shared Access Signature (SAS)
As I mentioned in my earlier blog, backup to URL is one of the common methods used in SQL Server performs a backup to Azure Blob Storage. In this blog, I am going to share a script to generate the create credential and backup command using Shared Access Signature also called as SAS token.
During Comprehensive Database Performance Health Check, I have recently a very interesting experience with an Azure. In this blog post, we will discuss which disks are preferred for performance – Standard Disks or Premium Disks. Well, honestly my answer here is very simple Premium Disks. If you stop reading this blog post over here, I am totally fine as well.