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 ... |
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
