Skip to content

tutorial-backup-restore-sql-server.md

Latest commit

 

History

History
73 lines (46 loc) · 3.02 KB

tutorial-backup-restore-sql-server.md

File metadata and controls

73 lines (46 loc) · 3.02 KB
title Backup and restore a database
description Learn how to backup and restore a database using Azure Data Studio
ms.prod azure-data-studio
ms.technology
ms.topic tutorial
author markingmyname
ms.author maghan
ms.reviewer alayu, maghan, sstein
ms.custom seodec18
ms.date 11/04/2019

Backup and Restore databases using Azure Data Studio

In this tutorial, you learn how to use Azure Data Studio to:

[!div class="checklist"]

  • Backup a database
  • View the backup status
  • Generate the script used to perform the backup
  • Restore a database
  • View the status of the restore task

Prerequisites

This tutorial requires the SQL Server TutorialDB. To create the TutorialDB database, complete one of the following quickstarts:

  • [Connect and query SQL Server using [!INCLUDEname-sos-short]](quickstart-sql-server.md)

This tutorial requires connecting to a SQL Server database. Azure SQL Database has automated backups, so Azure Data Studio doesn't perform Azure SQL Database backup and restore. For details, see Learn about automatic SQL Database backups.

Back up a database

  1. Open the TutorialDB database dashboard (open the SERVERS sidebar (CTRL+G), expand Databases, right-click TutorialDB, and select Manage).

  2. Open the Backup database dialog (click Backup on the Tasks widget).

    Tasks widget

  3. This tutorial uses the default backup options, so click Backup. backup dialog

After clicking Backup, the Backup database dialog disappears and the backup process begins.

View the backup status and view the backup script

  1. The Task History pane appears or press CTRL+T.

    Task history

  2. To view the backup script in the editor, right-click Backup Database succeeded and select Script.

    backup script

Restore a database from a backup file

  1. Open the SERVERS sidebar (CTRL+G), right-click your server, and select Manage.

  2. Open the Restore database dialog (click Restore on the Tasks widget).

    Restore Task

  3. Select Backup file in the Restore from field.

  4. Click the ellipses (...) in the Backup file path field, and select the latest backup file for TutorialDB.

  5. Type TutorialDB_Restored in the Target database field in the Destination section to restore the backup file to a new database. Then select Restore.

    restore

  6. To view the status of the restore operation, press CTRL+T to open the Task History.

    restore