How to Restore a SQL Server Database

Have a .BAK file you need to restore? Want to be prepared for the rainy day when something goes bad and you need to use one of those backups you've been so diligently creating? Restoring a database is a key task for anyone working with SQL Server, and it's easily done using SSMS or TSQL. Just remember to think first - do you want to overwrite the database from the backup, or create a copy from the backup? That decision is one you want to get right!

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Steve Bagwell on 7/9/2010

Excellent

Todd Burrell on 7/9/2010

As somewhat of a SQL Server newb, I wish this video had been published a couple of weeks ago. I ran into a scenario that I needed to restore a copy, but I didn't even know that "restore as" was an option, yet so simple after watching this video. Great series, Andy!

Steve Ramp on 7/9/2010

Nice and concise

Ed Svastits on 7/9/2010

Great overview with examples. A topic for a future video: disaster recovery - how (best practices) to restore a sql server (including master and msdb databases).

Ron Taylor on 7/9/2010

Basic but critical! Thanks

Christian Bahnsen on 7/9/2010

Great job, as usual.

E5F902EE1C on 7/9/2010

good clear speaker! good speed too

7CF6435DEF on 7/11/2010

I encourege to you to do more of this very helpful videos !!! ...and in fact: It's a b

Mohamed Irshad on 7/15/2010

cool

Faisal Lodhi on 7/21/2010

Awesome Clear Easy to Understand...please keep up the good work.

Robert Neal on 7/21/2010

Well done video on restore.

Leon on 7/23/2010

Great video. But is there also a possibility to do this with TSQL?

Uday on 10/11/2010

nice one,It would be great if we'll get all restore concepts in 1 video :)