Skip to content

lesson-4-perform-a-restore-from-a-full-database-backup.md

Latest commit

 

History

History
42 lines (31 loc) · 1.48 KB

lesson-4-perform-a-restore-from-a-full-database-backup.md

File metadata and controls

42 lines (31 loc) · 1.48 KB
title Lesson 4: Perform a Restore From a Full Database Backup | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology security
ms.topic conceptual
ms.assetid 580f76e6-9802-4abc-9043-db6de592c733
author VanMSFT
ms.author vanto
manager craigg

Lesson 4: Perform a Restore From a Full Database Backup

This lesson demonstrates the use of a tsql statement to perform a restore from a full database backup created in the previous lesson.

Perform a Restore of a Database Backup

To restore a full database backup, use the following steps:

  1. Connect to [!INCLUDEssManStudioFull].

  2. In the Object Explorer, connect to the instance of [!INCLUDEssCurrent].

  3. On the Standard menu bar, click New Query.

  4. Copy and paste the following example into the query window, modify as needed.

    RESTORE DATABASE AdventureWorks2012   
FROM URL = 'https://mystorageaccount.blob.core.windows.net/privatecontainertest/AdventureWorks2012.bak'   
WITH CREDENTIAL = 'mycredential';  
, STATS = 5 - use this to see monitor the progress  
GO

  5. Verify the T-SQL statement and click Execute

Return to Tutorials Portal

Tutorial: SQL Server Backup and Restore to Azure Blob Storage Service.