Join Martin Guidry for an in-depth discussion in this video Performing a basic restore using T-SQL, part of Microsoft SQL Server 2014: Backup and Recovery.
- [Voiceover] In this section we'll talk about…restoring a database from a backup file using T SQL.…Here in Management Studio I'll open up a new query.…I'll type in the keyword Restore,…and the keyword Database,…then I'll need to give the name of the database…with no punctuation marks.…Be it I'm restoring from disk, I'll need to use…the keywords From Disk, and immediately after disk…I'll put an equal sign, and then in single quotes…I'll put the name of the file I would like to restore from.…
And that should be it.…You notice this is very similar to the…syntax we used to perform the backup.…Instead of using the word backup, we use the word restore,…and instead of saying to disk, we say from disk.…But other than that, it is the same.…I'm gonna click Execute here.…I'm actually expecting to get an error,…but I want to show you that error…so that I can show you how to fix that error.…When I click Execute, it does say, Restore cannot process…database because it is in use by this session.…
So the problem is I have a query window connected…
- 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.