Azure Data Studio - Why Is Restore Option Missing Entirely

0 votes
I don't get it. Is the backup option no longer available in Azure Studio?
Mar 2, 2022 in Azure by Edureka
• 12,690 points
2,722 views

1 answer to this question.

0 votes

The SERVERS sidebar allows you to access the TutorialDB database dashboard. Then press Ctrl+G to expand Databases, right-click TutorialDB, and choose Manage from the menu.

  1. Select Backup from the Tasks widget to open the Database Backup dialogue box.
  2. The Tasks widget as seen in a screenshot.
  3. The default backup options are used in this tutorial, so choose Backup.
  4. The Task History window is shown in this screenshot.
  5. Right-click Backup Database Succeeded and select Script to see the backup script in the editor.
  6. This is a screenshot of the backup script.
  7. Ctrl+G will bring up the SERVERS sidebar. Then pick Manage from the context menu when you right-click your server.
  8. Select Restore from the Tasks widget to open the Restore database dialogue box.
  9. A screenshot of the Task Restore feature.
  10. In the Restore from box, choose Backup file.
  11. In the Backup file path box, click the ellipses (...) and choose the most recent backup file for TutorialDB.
  12. To restore the backup file to a new database, type TutorialDB Restored in the Target database box in the Destination section. Then choose Restore from the drop-down menu.
  13. Restore backup is seen in this screenshot.
  14. Select Ctrl+T to open the Task History and check the status of the restore procedure.
answered Mar 2, 2022 by Edureka
• 13,620 points

Related Questions In Azure

0 votes
1 answer

Why is Azure Key Vault secure?

A key vault is a safe place ...READ MORE

answered Mar 1, 2022 in Azure by Edureka
• 12,690 points
594 views
0 votes
0 answers

what is azure data lake

Jan 5 in Azure by Evanjalin
• 520 points
281 views
0 votes
1 answer
0 votes
1 answer

How to create table in Azure SQL Database?

Creating tables in Azure SQL Database: In Object Explorer, ...READ MORE

answered Jan 22, 2020 in Azure by Sirajul
• 59,230 points
37,083 views
0 votes
1 answer
0 votes
0 answers
0 votes
1 answer

Does Azure have a FREE tier?

When you join up for a free ...READ MORE

answered Apr 11, 2022 in Azure by Edureka
• 12,690 points

edited Jun 27, 2023 by Khan Sarfaraz 727 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP