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.
SQL SERVER – Msg 3292: A Failure Occurred While Attempting to Execute Backup or Restore With a URL Device Specified
In my recent project with a customer, they wanted to configure SQL backups to Azure Blob Storage. When we were trying to take a backup, we were facing error. In this blog we would learn how to fix error message 3292 – A failure occurred while attempting to execute Backup or Restore with a URL device specified.
Scalability and Availability Challenges and Shareplex Solutions
If you ask any DBA in the world about their wildest dream, they will always say that want to manage a huge database platform which is scalable whenever it needs to and available always. If you are a DBA, you will agree with the statement. Every DBA who is going home after a day-long work only dreams that a) he does not have to wake up mid-night and b) the first task next day is not to worry about the capacity of the server. Let us learn about Scalability and Availability Challenges and Shareplex Solutions.
SQL SERVER – Event ID:7034 – MSSQLSERVER Service Terminated Unexpectedly. It has Done this 6 time(s)
Recently, I came across a strange issue. I noticed that the SQL Server service terminates and restarts automatically and doesn’t restart.
SQL SERVER – Backup to URL – Script to Generate the Create Credential and Backup Command using Access Keys
Backup to URL is one of the common methods used in SQL Server perform backup to Azure Blob Storage. In this blog, I am going to share a script to generate the create credential and backup command using access keys.
SQL SERVER Analysis Services – Unable to Start Service. Error: The Filename, Directory Name, or Volume Label Syntax is Incorrect
Sometimes I get a chance to work on something which I have not worked earlier but I give my 100% before I give up. This gives me chance to learn something new and every time I get a new topic to write a blog. In this blog, we would learn about fixing “The filename, directory name, or volume label syntax is incorrect” error while starting SQL Server Analysis Services. Here is the exact message from system event log while trying to start the services using configuration manager.
SQL SERVER – Backup to Microsoft Azure Tool – ERROR: Account Verification Failed
I have been seeing many customers moving their SQL Server to Cloud. Few of them have chosen Microsoft Azure platform to host their production server and few others have selected other cloud platforms like AWS. When they host SQL in Azure, they can choose various backup methods. In this blog, we would learn about fixing an interesting error “Account Verification Failed” while using Microsoft SQL Server Backup to Microsoft Azure Tool.