How to restore files and filegroups (Enterprise Manager)

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, and then expand a server.
   
   
2. Expand Databases, right-click the database, point to All Tasks, and then click Restore Database.
   
   
3. In the Restore as database box, type or select the name of the database to restore, if different from the default.
   
   
4. Click Filegroups or files.
   
   
5. In the Restore list, select each file and filegroup to restore.
   
   
6. Click the Options tab, and then do one of the following:
   • Click Leave database operational. No additional transaction logs can be restored if no further transaction log backups are to be applied.
     
     
   • Click 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

Using File Backups