0

I need to backup a database I've got access to, but cannot find the option.

According to https://learn.microsoft.com/en-us/sql/azure-data-studio/tutorial-backup-restore-sql-server?view=sql-server-ver15 I can simply right-click the database, go to Manage, and it should be there.

I can right-click on the database and get a "Manage" option, but that just gives me some info:

enter image description here

Dan Guzman
  • 43,250
  • 3
  • 46
  • 71
user25730
  • 517
  • 2
  • 6
  • 24

1 Answers1

9

The Azure Data Studio database backup functionality is for on-prem or IaaS SQL Server databases. For Azure SQL Database, create a bacpac export instead. This can be done from within ADS by installing the SQL Server Dacpac extension for ADS.

Data-tier Application Wizard export option

Dan Guzman
  • 43,250
  • 3
  • 46
  • 71