Skip to content

tutorial-backup-restore-sql-server.md

Latest commit

 

History

History
87 lines (56 loc) · 3.09 KB

tutorial-backup-restore-sql-server.md

File metadata and controls

87 lines (56 loc) · 3.09 KB
title Backup and restore a database using SQL Operations Studio (preview) | Microsoft Docs
description Learn how to backup and restore a database using SQL Operations Studio (preview)
ms.custom tools|sos
ms.date 11/15/2017
ms.prod sql
ms.reviewer alayu; sstein
ms.suite sql
ms.prod_service sql-tools
ms.component sos
ms.tgt_pltfrm
ms.topic tutorial
author stevestein
ms.author sstein
manager craigg

Backup and Restore 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)

Backup 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. Open the Task History sidebar by clicking the clock icon on the Action bar 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).

  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.

    restore

  6. Click Restore

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

    restore

In this tutorial, you learned how 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