Join Martin Guidry for an in-depth discussion in this video Performing a basic restore using the GUI, part of Microsoft SQL Server 2014: Backup and Recovery.
- [Voiceover] In this section, we're going to talk about…restoring a database using the graphical interface.…I'm going to pull up SQL Server Management Studio…and I'll connect to the local instance.…I'll open up Databases,…I'll highlight one of the user databases,…right-click, go to Tasks,…then from there, I'll open up the restore menu…and I'll select the option for Database.…On the first page, at the top, I need to select the source.…
My choices are Database or Device.…I would like to restore from a file,…and in SQL Server terminology, that is a device.…So I'll highlight Device…then I'll click on the three dot button…all the way to the right,…and that will allow me select the file.…I'll go to Add…and then I'll select the file that I'm interested in using…for the restore.…Click OK,…OK again.…Now the machine has read the file…and pulled out certain information from it.…
It knows the name of the database,…it knows the date and time the backup was taken…and it gives me some other information at the bottom,…the name of the server, the name of the database,…
- Types of backups
- Media sets and backups
- Performing a basic backup using the GUI or command line
- Performing a basic restore using the GUI or command line
- Backing up and restoring logs
- Doing partial backup and restores
- Automating backups
- Using encryption and compression
Skill Level Intermediate
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
SQL Server 2014: Installation and Administrationwith Ron Davis3h 40m Intermediate
Migrating Access Databases to SQL Serverwith Adam Wilbert2h 38m Intermediate
1. Backups in General
4. Partial Backups and Restores
5. Other Backup Topics
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.