Welcome to Lesson 5 of the SQL Server 2000 Tutorial. In this lesson we will cover restoring a database. I hope you enjoy the lesson.

Restoring a Databases

Restoring A Database

If the most important thing is backing up a database, then the second most important thing must be the ability to restore a database from backups. 

To restore a database from backup, open up Enterprise Manager, navigate to the database tree, right-click, select All Task, select Restore Database.

The Restore database window opens with some default values.  We want to change them before proceeding.

On the Restore as Database: type in NorthwindTest.
On the Show backups of database: select Northwind.
A backup set should appear, make sure there is a check in the restore box and click OK

The database restore progress is displayed.

SQL has completed the restore of the database NorthwindTest.  Click OK.

 

Now if you look at Enterprise Manager, you will see a database called NorthwindTest.