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

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

To restore files and filegroups over existing files

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 From device, and then click Select devices.
   
   
5. Under Restore from, click Tape or Disk, and then select a device from which to restore.

   If no backup destinations appear, click Add to add an existing backup device or to create a new one. The backup device must reference the backup device files created at the primary server.

6. 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, type the backup set number in Backup number instead.

7. Under Restore backup set, click File or filegroup, and then type the names of the files you want to restore.
   
   
8. Click the Options tab, and then click Force restore over existing database.
   
   
9. Under Recovery completion state, 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.

See Also

Copying Databases