Recovering Databases

The following procedure walks you through a complete database restore operation for SQL Server using the SQL Server Enterprise Manager. This procedure is provided as a guideline only. The procedure for your operation may differ based on the type of backup you are restoring from and your backup storage media type.

1. Start SQL Server Management Studio.
2. Expand the tree under Console Root until you get to the Databases folder.
3. Select the database that you want to restore.
4. Right click on the Database folder and navigate to RestoreDatabase…
5. Select the Device>Ellipse button>Add to select the backup file.
6. Click OK.
7. Make sure the correct database is selected in the Database field.
8. Click OK in the earlier dialog to return to the Restore dialog.
9. Click OK to begin the restore process.