O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Performing a Database Restore

In the previous section, you learned how to use database backups and transaction logs to get up to the point of disaster restore. This section covers the necessary steps and commands to restore a SQL Server database using SQL Server backups.

NOTE

The database being restored cannot be in use while you are trying to restore it.

To restore a corrupted, suspect, damaged, missing, or moving database, perform the following:

1.
From the SQL Enterprise Manager, select Tools and then select Restore Database. The Restore Database dialog box appears (see Figure 10.16).
Figure 10.16. The Restore Database dialog box—General tab.
2.
Use the Restore as Database combo box to select the database to restore to.
3.
To select ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required