How to restore files and filegroups over existing files (Enterprise Manager)

To restore files and filegroups over existing files

Expand a server group; then expand a server.
Expand Databases, right-click the database, point to All Tasks, and then click Restore Database....
In Restore as database, enter or select the name of the database to restore if different from the default displayed.
On the General tab, select From device.
Select Select devices....
Click Add... to specify each backup device containing the backup from which you need to restore.
In the Choose Restore Destination dialog box, specify either the name of the file or the backup device containing the backup.
In the Restore Database dialog box, click View contents.... Select the backup set to restore.

Note This option scans the backup set for the backup content information and can be time consuming, especially when using tape devices. If you already know the backup set to restore, enter the backup set number in Backup number instead.
Select File or filegroup. Enter the names of the files you want to restore.
On the Options tab, select Force restore over existing database.
On the Options tab, select:
- Leave database operational. No additional transaction logs can be restored if no further transaction log backups are to be applied.
- Leave database nonoperational, but able to restore additional transaction logs if another transaction log backup is to be applied.