backup to blob azure with sa account

• abdalah.mehdoini

  Ten Centuries

  Points: 1012

  More actions

  September 8, 2020 at 2:52 pm

  #3787016

  Good morning all

  I must make backup to Azure BLOB URL Can I do this type of backup with the SA account or do I need a specific account?

  thank you for your explanation

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  September 8, 2020 at 9:41 pm

  #3787140

  Your backup command needs the shared keys to access a blob. Your account just needs normal backup rights

  https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url?view=sql-server-ver15