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.

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.

denacho on 1/7/2009

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

Travis on 5/27/2009

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!

WChaster on 5/27/2009

Guess I could not infer.

Tim Harms on 5/27/2009

We definitely need to know that in versions after SQL Server 2000.

Diana Dee on 6/1/2009

(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

Carla Wilson on 6/4/2009

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.

Michelle Rosenaur on 10/9/2009

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!

Neerav on 2/25/2010

It was simple, easy to understand and to the point