How to backup a database in "Azure Data Studio" Desktop app.

Chuck Roberts 65 Reputation points
2023-10-05T11:29:50.18+00:00

I'm watching a LinkedIn video from Aug 2022. I'm very new to the Azure world. The ADS desktop app interface has changed as each server connection now has the database listed on it, so there is no database tab or any option to backup or restore a database in the ADS app itself. My database is stored on the Azure could itself. It is not a local database. This database is for practice while I do a tutorial.

  • So how do we backup a database now?
  • Is that feature disabled for now?
  • Or do I have to use the Azure Data Studio via the Azure web portal?
  • Could backup be an additional service we have to pay for?

I went to the Azure portal online and don't see any backup options for my specific database. I also scanned all the options on the left sidebar.

When I click on a server in ADS I get this:

User's image

When I right click a server I get this:

User's image

Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
100 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 41,411 Reputation points
    2023-10-05T11:35:57.04+00:00

    Connect to the SQL Server, click on the server note, then you get a pane "Databases", click on it, you get a list of databases, then rigth-mouse on the database in mid => Backup

    Or wirte a simple BACKUP command in SQL

    https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-ver16


0 additional answers

Sort by: Most helpful