Skip to content

tutorial-backup-restore-sql-server.md

Latest commit

 

History

History
74 lines (47 loc) · 3.11 KB

tutorial-backup-restore-sql-server.md

File metadata and controls

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

Backup and Restore databases using [!INCLUDEname-sos]

In this tutorial, you learn how to use [!INCLUDEname-sos] 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