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.