2

I have created an azure SQL database, single database. I would like to see where my backup files are saved. I know in Data Management > Backups I can see my database and can configure retention policies. My question is where are the backup files? I want to restore them in another Azure SQL datbase, either database server or in a SQL managed instance, or simply keep them in some blob for archiving purpose. This is also my issue with Azure SQL database, database server.

enter image description here

As shown in the image above only databases are there with their policies, but the location of saved backups is unclear to me. Thank you for your valuable input.

E. Erfan
  • 1,239
  • 19
  • 37

1 Answers1

1

I have created an azure SQL database, single database. I would like to see where my backup files are saved.

That is not possible. The backups are stored securely with no direct customer access. You can restore to another Azure SQL Database, or create a logical export to a BACPAC file.

David Browne - Microsoft
  • 80,331
  • 6
  • 39
  • 67
  • Thanks David. There is also no way to determine full, differential or transaction log backup? – E. Erfan Dec 22 '21 at 23:08
  • I followed the link you shared to create a logical export to a bacpac file, but it fails. I explained the issue in this link: https://stackoverflow.com/questions/70456053/azure-sql-exports-fail-to-backup-in-blob-container if you can kindly have a look. – E. Erfan Dec 22 '21 at 23:10