Restore Files and Filegroups (General Page)

To database

Enter the database to restore in the list. You can enter a new database or choose an existing database from the drop-down list. The list includes all databases on the server, excluding the system databases master and tempdb.

From database

Select the database to restore from the list box. This list contains only databases that have been backed up according to the msdb backup history.

From device

Select one or more tapes or disks as the source for the backup sets. Click the browse button (...) to select one or more devices; the device names appear as read-only values in the From device list.

Select the backup sets to restore

Displays the backups available for the specified location. By default, a recovery plan that achieves the goal of the restore operation is suggested based on the selection of the necessary backup sets. To override the suggested recovery plan, you can change the selections in the grid.

Header	Values
Restore	The selected check boxes indicate the backup sets to be restored.
Name	The name of the backup set.
File Type	Specifies the type of data in the backup: Data, Log, or Filestream Data. Data that is contained in tables is in Data files. Transaction log data is in Log files. Binary large object (BLOB) data that is stored on the file system is in Filestream Data files.
Type	The type of backup performed: Full, Differential, or Transaction Log.
Server	The name of the Database-Engine instance that performed the backup operation.
File Logical Name	The logical name of the file.
Database	The name of the database involved in the backup operation.
Start Date	The date and time when the backup operation began, presented in the regional setting of the client.
Finish Date	The date and time when the backup operation finished, presented in the regional setting of the client.
Size	The size of the backup set in bytes.
User Name	The name of the user who performed the backup operation.

Tasks

Concepts