Restoring SQL Server database files

This topic describes how to restore database files.

To restore a database file

Browse for the backup images you want to restore.
In the Restore Microsoft SQL Server Objects dialog box, expand the database instance and the database.
Expand the filegroup that contains the file you want to restore.
Expand the file.
Select the database file image that you want to restore.
Select the restore options.
Click Restore.
To view the progress of the restore, select File > View status.

More Information