Join Martin Guidry for an in-depth discussion in this video Troubleshooting restores, part of Microsoft SQL Server 2014: Backup and Recovery.
- [Voiceover] When restoring from backup…there are a few common errors that occur.…I'd like to show you some of those errors,…and show you how to solve those problems.…So here I have a basic restore statement.…When I go to execute it I get the error…restore cannot process database…because it is in use by this session.…So when I have the adventure works 2014 database open,…I cannot restore to it,…so therefore I need to move these commands…into the context of a different database.…
Most commonly we do this by just adding the phrase,…use master at the top.…And that will put me in the context of the master database,…and will solve the problem of cannot process database…because it is in use by this session.…But we're going to have a different problem.…When I hit execute…this should take about 20 seconds,…and then we're going to see an error.…The error we'll see next is caused by…there is another connection to the database.…Someone has an active open connection the database,…and while that is true we cannot do a restore.…
- 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.