From the course: SQL Server 2014 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Basic restore

Basic restore - SQL Server Tutorial

From the course: SQL Server 2014 Essential Training

Start my 1-month free trial

Basic restore

“

- In this section, I'd like to look at doing a basic restore of the backup we did in the previous section. I'll right click on the AdventureWorks Database, again I'll go to Tasks, and this time I'll go to Restore. I'll have one more level of options to choose from. And it is in fact that Database I would like to restore. So I'll select Database. This will pull up a dialogue. I would like to restore from a device, in this context a take drive or a file on disk as a device. Now I need to click on the three little dots to choose the file I'd like to restore from. When I click on that it'll bring up a dialogue for Select Backup Device, I'll hit Add, and that'll take me to a File Explore, where I can find the backup file from the previous exercise. I'll click OK there, I'll click OK on Select Backup Device, and it found a backup set in there that has the name we had given it previously, and that's everything I need on this page. Now we'll go to the Files page. It shows the files that will…

Contents