CODEWITHSUNDEEP
azureazure-sql-databaseazure-data-studio
user25730
user25730

Reputation: 739

Azure Data Studio - cannot find backup option

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

Upvotes: 5

Views: 6157

Answers (1)

Dan Guzman
Dan Guzman

Reputation: 46320

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

Upvotes: 16

Related Questions