Backing up an Azure SQL Database hosted on Azure VM onto an Azure File Share.

• satnam.singh 44358

  Ten Centuries

  Points: 1300

  More actions

  March 22, 2022 at 12:40 pm

  #4004145

  Team,

  Can we create a credential using SAS Key for an Azure File Share with extension .file.core.windows.net and Backup an Azure SQL Database onto it; Right Now i receive the Error "Error while decoding the storage key."

  With Thanks,

  Satnam

   

   

• Grant Fritchey

  SSC Guru

  Points: 398999

  More actions

  March 22, 2022 at 1:16 pm

  #4004176

  Microsoft has some fantastic documentation on exactly how to get your backups done in Azure VMs. Pretty much everything you need. Don't forget though, untested backups are unknown. The only complete test is a restore. Strong recommendation to test restores regularly.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning