|
Author:
Author Bio:
Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.
|
|
|
Restoring a Full Backup of a Database in SSMS
Author and MVP Brian Knight explains how to use restore to create a copy of a database, and of course you can always just restore the database to replace the one that already exists.
|
Video Information
|
Publish Date:
|
December 01, 2008
|
Length:
|
2:36
|
Skill Level:
|
100
|
Rating:
|
4.08 out of 5
|
|
|
|
|
After watching you should be able to answer these questions:
- This wasn't clearly explained in the video, but we'll see if you can infer the right answer - why would you use a device instead of selecting from the backup history in the RESTORE dialog?
- What problem is indicated if you get a 'with move' error?
|
Watch Video Now! Watch it later! Take Quiz For Video Now!
|
|
|
|
|
|
Comments:
|
|
brian has a very friendly demeanor in his tutorials, but his constant verbal stumblings are distracting. seems nervous and that doesn't come across as smoothly as i wish it did.
|
|
Bill Nicolich on 5/27/2009
Something about how the information was presented made it difficult to understand--perhaps spoken too fast with words almost jumbled together or something.
|
|
Philip Hickey on 5/27/2009
These short and to the point videos are excellent.
|
|
Steve Harris on 5/27/2009
good to mention that there are other parts to the restore process and that they will be covered on other videos
|
|
Jamshid Nouri on 5/27/2009
Excellent demo
|
|
|
Brian needs to take the marbles out of his mouth and slow down. For such a celebrated author and noted expert on SQL Server, his speaking skills are terrible!
|
|
|
Guess I could not infer.
|
|
|
We definitely need to know that in versions after SQL Server 2000.
|
|
|
(1) Brian talks and points-and-clicks way way too fast. I am a certified DBA and MCT on SQL Server and I still could not tell what he was doing! I am previewing this for possible use by my students. (2) Brian has several word errors e.g. "backup" instead of "restore." He should have recorded this again more slowly with fewer errors. (3) Asking a question not covered is very bad, IMHO. -- I respect Brian for his knowledge and am giving this feedback in hopes he does not make the same errors in future videos! Diana Dee
|
|
|
I am interested in saving the restore to a script - I have a project where using the script could be very useful. Thanks for mentioning that.
|
|
|
Just what I needed! Started to restore in SQL Server 2005 for the first time and was confused because the interface was a little different than SQL Server 2000. Thanks!
|
|
|
It was simple, easy to understand and to the point
|
|
|
|
|
|
|