How to restore files and filegroups (Enterprise Manager)

Note If you are restoring a file or filegroup backup that does not have any backup set information listed in the backup history stored in the msdb database, such as a file or filegroup backup created on another server, see How to restore a backup from a backup device.

To restore files and filegroups

1. Expand a server group; then expand a server.
2. Expand Databases, right-click the database, point to All Tasks, and then click Restore Database....
3. In Restore as database, enter or select the name of the database to restore if different from the default displayed.
4. On the General tab, select Filegroups or files.
5. In Parameters, select Restore for each file and filegroup to restore.
6. 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.

Important If the files have been modified since the file backup was created, transaction log backups created after the file backup must be applied.

See Also

Restoring File or Filegroup Backups